I have used SQL server 2000 running queries and ran some basic queries for creating database.
I installed Microsoft SQl 2005 and now I a bit confused.
Where can I find my Query analyser and Run the query and execute it. 2000 had a simple and neat designs for simple execution but what about SQL 2005.
Any suggestions Its a silly question but I need to run one project and I am not able to run SQL. Any help apprectaied
I tried going to this location
Start menu, ---> All Programs, ---> Microsoft SQL Server 2005,
then ---> SQL Server Management Studio.
I am not finding SQL Server Management Studio.
I can see configuration tools and Documentaion and tutorials.
Do you think I need to reinstall 2005
Or is there any configuration I need to do.
Thanks
-Arun
SQL Server 2005 basics
Glider
What edition of SQL Server 2005 are you using
If you are using SQL Server Express:
-- The initial release did not ship with Management Studio. We currently have a Community Technology Preview (CTP) of the SQL Server Management Studio Express. You can go to http://msdn.microsoft.com/sql/express/ for more information and installation instructions.
If you are using SQL Server Workgroup Edition, Standard Edition, Developer Edition, or Enterprise Edition:
-- My guess is that you didn't install the client tools with your SQL Server installation. In this case, you need to run SQL Server 2005 Setup again and choose to install the client tools. You will NOT have to reconfigure your server or uninstall your existing server.
If these solutions do not solve your problem, please post more information so we can explore other options.
Thanks,
-Paul
ArtT
it could be, that if you installed one of the VS Express editions for developing that another toolset for SQL Server has been installed. If so simply deinstall the scaled down featureset and install the one from the SQL2k5 Dev Edition.
If you haven’t installed VS Express and only SQL Server 2k5 Dev it could be that you missed out some feature of the management studios. Its quite easy to miss out some things from there.
HTH, jens Suessmeyer.
---
http://www.sqlserver2005.de
---