Forum Moderators: open
having a problem setting up a database i have been provided with. I'm trying to install it to a dummy server on my machine for testing.
I've installed SQL Server 2005. In the start menu folder for this it lists one sub folder, called configuration tools.
There are three items in the subfolder, configuration manager, error and usage reporting and surface area manager.
Now, here's my problem, the documentation i recieved with the database (i didn't write it myself) states the following
Quote:
In order to create the main database, run project.sql from Microsoft SQL Server Query Analyzer. Once the database is created, run projectdata.sql in the Query Analyzer. Please ensure you run one after the other as the second script takes the database location from the first script
My question is how do i run the server query analyzer? There's no exe for it on my machine, am i missing software? or is it a command line program, if so how do i run it?
Many thanks in advance. This has been stumping me since yesterday.
D
if you open query analyzer you can select OPEN SCRIPT from the file menu it will find .sql files, point it to the first one and click ok. you will now see a whole big script in your window. once you see it, press F5 to run it. once its done, open the other script and press F5 to run that one.
Query analyzer opens and plays .sql file types. As they are SQL Scripts. Hope this helps you.
mcm
