Query Analyser - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Query Analyser

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-10-03 : 07:54:08

Sridhar writes "Hi,
In SQL server 2000 Query Analyser
It takes unusally Long time if i try to change the Database using the combobox for selecting Database.
How can it be rectified

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Thanks"

Kristen
Test

22859 Posts

Posted - 2005-10-03 : 12:58:41

Hi Sridhar, Welcome to SQL Team!

Type

USE MyDatabase

and run that instead?

Kristen

X002548
Not Just a Number

15586 Posts

Posted - 2005-10-03 : 13:01:59

You must have a lot of databases

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Kristen
Test

22859 Posts

Posted - 2005-10-03 : 13:20:33

Or slow connection?

Kristen

WYSIWYG
Starting Member

15 Posts

Posted - 2005-10-04 : 08:41:29

Does not hurt to defrag also ... I like Diskeeper Lite (the free version)

Google: dklite.exe download

[url]http://www.diskeeperlite.com/[/url]
[url]http://www.majorgeeks.com/download.php?det=1207[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources