Unknown error messages during generate script from SQL2008 database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unknown error messages during generate script...

Unknown error messages during generate script from SQL2008 database

Rate Topic

Display Mode

Topic Options

Author

Message

yu_wai

Posted Monday, March 23, 2009 7:11 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 18, 2013 8:26 PM
Points: 11, Visits: 145

I have a SQL2008 database, running Standard Edition 64-bit, database owns by sa, connected to Management Studio using Windows Authentication mode. When I tried to generate scripts from a database, I got the following error messages:-

[Operation is not valid due to the current state of the object. (SqlManagerUI)]

which happened at one particular table. I have reviewed this table definitions are normal, and I could select data from it.
I couldn't find any information anywhere relating to this error messages, except that someone got it when they were trying to change the authentication mode or sa password.

Anybody got this similar scenario ? any idea would be appreciated....

Wai

Post #682015

viorel.ruicu

Posted Monday, March 30, 2009 7:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 7:50 AM
Points: 7, Visits: 85

did you found a solution to ur problem?
also i have the same problem

Post #686080

yu_wai

Posted Tuesday, March 31, 2009 6:03 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 18, 2013 8:26 PM
Points: 11, Visits: 145

I finally found that I had some other windows opened to view some objects with the same database when I tried to generate scripts. Once I closed those windows, the error messages gone. This is probably Management Studio still occupying some of the objects that I have opened.

Hope that helps you....

Post #687573

« Prev Topic | Next Topic »

Permissions