How to run SQL server management studio 2005 for the first time.

So.. you have installed SQL server management studio...

Congrats. but now what to do....???

Read on....

Here are easy steps to run your studio for the first time.

1. Open sql server management studio from the start menu. I will show you the login Screen.

     2.    Out of 3 options, select Databse engine in the first option. Enter your Computer Name in the second one. And  select Windows Authentication in the third option.
    3.    Click Connect...(And u r flying..)   
In Some cases, you may get this following error...

or an error saying you are not authorised to make database.. in that case, close the SQL server management studio and open it again, this time right click on the sql server management studio and select the option that says "Run as administrator".

its that simple !!
until next time..
keep clicking !!!
100rabh

How to add Northwind databse to sql server 2005

Hi Everybody,
Northwind database is a free sample database provided by Microsoft and is a really nice practice database. it covers almost all the aspects of sql queries that you may ever encounter.
if you are using sql server 2005 management studio, you dont get Northwind by default.
so here is a quick 4 step guide to install Northwind into SQL server 2005 management studio.
Step 1. Click here to download Northwind.msi.
Step 2. Run and install the downloaded file.
Step 3. The installation will make a C:\SQL Server 2000 Sample Databases folder, open sql server 2005, click on file>>Open>>file>> and point it to a file called instnwnd.sql at the location mentioned above. 

Step 4. It will open a huge query file in the sql server, now just press f5 to execute this and the northwind database will be ready in your object explorer.

Happy practicing !!!