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!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Funky Error on Return all Rows 1

Status
Not open for further replies.

nzgirl

Programmer
Joined
Feb 26, 2003
Messages
72
Location
NZ
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
:-)
 
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:
 
Thanks!
We reststarted it this morning and all is well :-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top