Sunday, February 19, 2012

How to use .SQL scripts

In Enterprise Manager, I clicked on my database, then clicked tools, generate sql script. I created the script so that it would script all tables, keys, etc... Now how do I use this script on a new SQL server to setup my database?Go to Enterprise manager tools Query Analyzer and paste it and click on execute. Hope this helps.|||

Thank You

|||

How can Iexecute the sql scripts on a remote server?

|||Same way just remote in click on programs SQL Server then go to Enterprise manager assuming you have Admin permissions on the remote server. You can do everything and it feels local. Hope this helps.|||

I don't have admin permissions butfound this and this works
http://www.mattberther.com/2005/04/000619.html
I can post my code if needed


No comments:

Post a Comment