June 30, 2011 at 12:51 am
Sql script required to generate database object script.
June 30, 2011 at 6:53 am
In SQL Server Management Studio, right click on the database in question and select "Tasks" - "Generate Scripts" and follow through the process there. You should be able to script out everything you need that way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 30, 2011 at 7:54 am
I am looking for if it is possible using sql query.
June 30, 2011 at 8:08 am
Just using a SQL Query? No.
You can program it, but you'd want to look into using something like Powershell in combination with SMO in order to do it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply