Creating database from script

I have a script that creates a database and empty database tables with constraints from SQL Server 2000. How do I go about running this script using SQL Server 2005 Management Studio to create this database as SQL Server 2005?

Can someone help by guiding me throught the process?
LVL 35
YZlatAsked:
Who is Participating?
 
ErezMorConnect With a Mentor Commented:
in management studio, fo to File->Open->File... and point to the file/s with the scripts
then, when displayed (as tabs with the scripts inside) click the Execute button on each (of course in the right order (db creation, then tables then relations etc...)
good luck
0
 
PIERCGGCommented:
In SSMS, choose FILE/OPEN and then point to your sql file to open it.  Then execute it.
0
 
YZlatAuthor Commented:
Thank you! I ran the script but now I cannot find my stored procedures. Where would they be?
0
 
YZlatAuthor Commented:
found them! Thanks!
0
All Courses

From novice to tech pro — start learning today.