Funky Error on Return all Rows 1

nzgirl · Mar 18, 2003

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 · Mar 18, 2003

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 · Mar 18, 2003

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 · Mar 19, 2003

Thanks!
We reststarted it this morning and all is well

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Funky Error on Return all Rows 1

nzgirl

Programmer

tlbroadbent

MIS

osjohnm

Technical User

nzgirl

Programmer

Similar threads

Part and Inventory Search

Sponsor