Hi,
I'm Connecting to server on the internet. When I connect with the SQL Query analyzer it works fine.
but when I open the Enterprise Manager & Click on the database then It loads all the databases from the server. & it takes a lot of time. What I want that to load only specific databases or any other method by which I can improve its performance.
I hope you get that.
thanks in advance,
Das
I don't think you can change that behavior, but you can certainly increase
the timeout value for Enterprise Manager. For more informaiton, see:
http://vyaskn.tripod.com/sql_server_tools_faq.htm#q7
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Das" <anonymous@.discussions.microsoft.com> wrote in message
news:A50CF25F-A767-4BA9-BE5E-5E046346F362@.microsoft.com...
Hi,
I'm Connecting to server on the internet. When I connect with the SQL Query
analyzer it works fine.
but when I open the Enterprise Manager & Click on the database then It
loads all the databases from the server. & it takes a lot of time. What I
want that to load only specific databases or any other method by which I can
improve its performance.
I hope you get that.
thanks in advance,
Das
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment