Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problems generating sql script

Author  Topic 

gtvt6
Starting Member

3 Posts

Posted - 2005-08-26 : 11:30:17
I am trying to generate sql script through Enterprise Manager (tables, sp, database, users), when I try running the script I get an error that states that the Database does not exist, but when I generate the script for another db everything goes good.

Are there any known issues with this feature?

The db that is throwing the error does have several relationships defined, could this play a part in it?

X002548
Not Just a Number

15586 Posts

Posted - 2005-08-26 : 11:36:43
I would try DBCC CHECKDB for that database....

Try stopping and restarting Enterprise Mangler



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

gtvt6
Starting Member

3 Posts

Posted - 2005-08-26 : 12:09:40
I performed the DBCC CHECKDB on the problem database and retrived 0 errors.

Any other ideas that could be causing this?
Go to Top of Page
   

- Advertisement -