This tip is useful for SQL Server newbie. The author demonstrates this by creating a database, changes the configuration such as Auto Shrink, Restrict Access...then using SQL Server Management Studio to generate scripts for the whole operations.
This is useful in the situation such as when you want to deploy the template database to different SQL Server Instance.
Refer the full information here:
http://dattatreysindol.com/2012/06/13/tips-n-tricks-ssms-script-your-actions-in-ssms-to-easily-generate-t-sql-scripts/
Script your operations in SQL Server Management Studio
0 comments:
Post a Comment