Hi,
I use the Enterprise Manager frequently and then have quite a few tables
opened. I spend half my day (well, it feels like that anyway...) clicking
away the messageboxes "Do you want to continue working with this resultset"
and "the pane has been cleared to save resources".
I understand why SQLServer 2000 wants to do this, I just don't want those
messageboxes... is there a way to tell the EM that for the rest of my life
I don't want to continue working with any resultset until I run the query
again? It would be a lifesaver for me!
Thanks!I recommend you avoid editing tables in EM. Occassionaly opening a table for
review in EM is reasonable enough but Query Analyzer is actually a much more
powerful tool for querying and updating data. QA doesn't cause the same
problems. See:
http://www.aspfaq.com/show.asp?id=2455
David Portas
SQL Server MVP
--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment