Installing SQL Server 2005 Express Ed

Hi All,

I'm new to programming and I've got to develop a db for a uni project. However after downloading SQL Server 2005 express ed, I found that I could not find the command prompt to start writing scripts (black and white DOS screem). I only have the configuration tool option in my menu (within that server configuration manager, error & usage reporting and server surface area config).

How do I get started with creating my database, please help....................

I'm I not looking in the right place for the console (command prompt to run scripts) or have I not downloaded the right stuff.

I need help urgently!!!

Thanks, in advance

First thing, if you haven't already done so, download and install the Documentation and Samples for SQL Server 2005 Express Edition:

http://www.microsoft.com/downloads/details.aspx?familyid=9697AAAA-AD4B-416E-87A4-A8B154F92787&displaylang=en

There are a few ways to get started creating databases, run scripts, etc:

1. Install SQL Server Management Studio Express:

http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

2. Install a Visual Studio Express version

3. Open up a command shell and run sqlcmd -S <server\instance>

jeff.

|||

I downloaded SQL Server 2005 developers edition and in first go I could only install Server. The setup did not install client tools, BOL etc. I had to manually goto CD2 and setup.exe to install client tools and BOL.

|||

Thanks for the reply

I have installed the documentation and samples and the management studio, but when trying to work through the samples, I get this error message, for some reason I can't include the Adventure works db. What can I'm I not doing

1> SELECT name from sys.databases
2> Go
name

--

master

tempdb

model

msdb

1> CREATE DATABASE [AdventureWorks] ON
2> (AdventureWorks = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
< AdventureWorks>.mdf' ),
3> (AdventureWorks = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
< AdventureWorks>.ldf' )
4> FOR ATTACH ;
5> GO
Msg 153, Level 15, State 1, Server YOUR-V7OY5L24PG\SQLEXPRESS, Line 2
Invalid usage of the option AdventureWorks in the CREATE/ALTER DATABASE statemen
t.
1> USE [master]
2> GO
Changed database context to 'master'.
1> CREATE DATABASE [AdventureWorks] ON
2> (AdventureWorks = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
< AdventureWorks>.mdf' ),
3> (AdventureWorks = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
< AdventureWorks>.ldf' )
4> FOR ATTACH ;
5> GO
Msg 153, Level 15, State 1, Server YOUR-V7OY5L24PG\SQLEXPRESS, Line 2
Invalid usage of the option AdventureWorks in the CREATE/ALTER DATABASE statemen
t.
1> select name from sys.databases
2> go
name

--

master

tempdb

model

msdb

(4 rows affected)
1>