SQL Server

[zebnoon]

Hello to all,
I have installed SQL Server 2005 on windows xp . Please tell me how can i create new SQL database ?

[Fenrir()]

Just open SQL and right click on the "Databases" node in the Object explorer -> New Database. when the new database form pops up simply type a database name and click okay.

[zebnoon]

but here is only cofig.no and sql manager studio?

[adam_k]

Is it express edition?

[zebnoon]

yes ..it is express edition

[adam_k]

Read here: http://msdn.microsoft.com/en-us/library/ms233763(v=vs.80).aspx

[zebnoon]

I already installed on Win xp but ,i havnt Management studio in option..

[Pgmer]

It has not got installed properly or try restart ur system.

[zebnoon]

i restarted ,, but problem is not solved.

[Pgmer]

Have you given proper instance name while installing? or any other Sql server version already there in your system?
can remove from control panel and try re installing?

[zebnoon]

sir i did this process 3 times .i downloaded Management studio sapratlly , installed it but there was prob lem to extract. what can i do please help me..

[Pgmer]

Go to control panel remove everything releated to SQL server. Then install with proper instance name and restart your system. i cant predict what exactly is the problem..

[zebnoon]

Hi all ,
still i have problem with intallation SQL Serever 2005.I installed SQL server 2005 with adv servies ,there is no any Sql server Management Studio.I have to download it sapreatly and install it?First of all i have to install SQL Server or Microsoft SQL Server Management Studio?plz help me.

[Netcode]

Do a system restore to a date before you installed sql server, try re-installing SQL Server and be careful no to change names or properties where not necessary

[zebnoon]

i didnt understand plz answer me......How can i install Microsoft SQL Server Management Studio,?

[ChrisHunter]

have a look at this