Hello every one
i downloaded "microsoft sql server 2005" and installed it correctly but i m now confused b'coz i can't find Query Analyser.Can any one help me out of the situation .

Re: Query Analyser Missing 80 80

I'm guessing you are coming from a SQL 2000 environment. If you want to write a query, just click the New Query button. You can also analyze the query in the Database Engine Tuning Advisor (Tools->Database Engine Tuning Advisor).

Re: Query Analyser Missing 80 80

well thnx 4 da reply,but after installation of the software i got only "Configuration Tools" .

Re: Query Analyser Missing 80 80

Yo should download SQL Server Management Studio Express from Microsoft download center

Re: Query Analyser Missing 80 80

Oh, SQL Server Management Studio didn't install. Which version did you install? Standard? Express? As long as it wasn't the Express edition, you should be able to install SSMS. If you installed Express, follow JuhaW's instructions above and install the scaled down Express version.
It should have installed on it's own, but there are known issues:
http://aspadvice.com/blogs/name/archive/2007/09/24/Installing-SQL-Server-Management-Studio-with-SQL-Server.aspx

Re: Query Analyser Missing 80 80

Hello every one
i downloaded "microsoft sql server 2005" and installed it correctly but i m now confused b'coz i can't find Query Analyser.Can any one help me out of the situation .

SQL Query Analyzer is of SQL Server 2000 but SQL 2005 doesnt have.
You will need SQL Management Studio Standard/Express, search for the setup from google and install.

Re: Query Analyser Missing 80 80

Thanx a lot buddies my problem was solved after i downloaded "SQL Management Studio Express" :). Earlier i only downloaded "Microsoft SQL 2005 Server Express Edition" .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.