Script don't work 2

[graabein]

Hi, I'm working on several SQL Server 2000 databases and I want to copy my changes from one test database to another.

I have generated one SQL script that copies every table and stored procedure and when I run it in query analyzer it says command executed successfully, but when I look at the database where I ran it, the new tables and procedures are not there!

What am I doing wrong?


graabein

 

[laradegroot]

Assuming you are using SQL Server Enterprise manager to check your database, I sometimes have to exit this program and reopen it before changes have taken place.

In any case, helping you would be a lot easier if you would also list your code!

Good luck!

Lara

 

[mayB2morrow]

I presume you are looking at the db through Enterprise manager?

If so, have you clicked the refresh button on each view after running the script. An annoying thing about Enterprise Manager is that just expanding the various views in the tree (e.g. Tables, Views, etc) does not refresh their contents, you have to do this manually using the Refresh icon on the toolbar.

Failing that, check you have run the script on the correct server etc.

Hope this helps,
Phil.

 

[graabein]

I did use the refresh button and opened/closed nodes in the tree. When I started Enterprise Manager just now the new tables and procedures where in place... Strange. But now I'm set. Thanks!