Holy Cow!, I've experienced the complete opposite with SQL 2005. The EM takes forever to do anything. Also, I was trying to debug why some of my queries went from 20ms to ~20s to run. Come to find out, if the table was open in data or design view in EM, it was slowing down access to that table. I'm really crossing my fingers for some better performance soon.
On 2/6/06, Peter Tilbrook <[EMAIL PROTECTED]> wrote: > I'm with Mike on this one (same provider) and have been using Enterprise > Manager for years with no issues and a full understanding of the security > implications. EM can be slow but the new EM for SQL 2005 seems to be a bit > better - not that I will need to use it apart from local db's it seems. > > One thing I do not like about EM is you get a full list of databases on the > server and not just your own so that could be a security weakness if people > do not have strong passwords. > > Mind you the provider has Northwind installed on a live server. Even on my > dev boxes I remove it. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231545 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
