Hi friends,
I want to know How to create script file in sql server and run a *.sql script file ? with example.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted May 21, 2012, 11:46 PM
Are are want to create script file using SSMS(managament Studio)?
which type of script you want to generate?
I think,
Please refer..
http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
http://www.mssqltips.com/sqlservertip/1758/generate-scripts-for-sql-server-2008-object-migration/