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>
