We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Creating database from script

YZlat
YZlat asked
on
Medium Priority
254 Views
Last Modified: 2012-05-07
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?
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
In SSMS, choose FILE/OPEN and then point to your sql file to open it.  Then execute it.
CERTIFIED EXPERT

Author

Commented:
Thank you! I ran the script but now I cannot find my stored procedures. Where would they be?
CERTIFIED EXPERT

Author

Commented:
found them! Thanks!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.