Funky Error on Return all Rows 1

[nzgirl]

Enterprise Manager for Sql Server 7
Return all rows gives : Query Designer encountered a Query error : Unspecified Error.

Yet select * on the same table through Query Analzyer gives the correct data..

does this ring any bells? My DBA has just gone home for the day.....

Thanks

 

[tlbroadbent]

Enterprise Manager has an assotment of bugs. You may have discovered one of them. I don't recall geting that error so I probably can't help much. Do you have the latest Service Pack (SP4) for SQL Server 7 installed? If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[osjohnm]

Hi

Have a look at the following article at Microsoft's support website. It seems that this occurs if the server hasn't been restarted for awhile. This is on a SQL Server 7 issue.

http://support.microsoft.com/default.aspx?scid=kb;en-us;273472

Hope this helps

John

 

[nzgirl]

Thanks!
We reststarted it this morning and all is well