Get script for every action in SQL Server Management Studio

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 20 Dec 2010 07:00:00 UT Indexed on 2010/12/20 17:52 UTC
Read the original article Hit count: 221

Filed under:
I am always conscious to keep a record of all operations performed on my database servers. Operations through T-SQL in an SSMS query pane can easily be saved in query files. For table modifications through SSMS designer I have predefined setting to generate T-SQL scripts. However there are numerous database and server level tasks that I use the SSMS GUI and I would like to have a script of these changes for later reference. Examples of such actions through the SSMS GUI are backup/restore, changing compatibility level of a database, manipulating permissions, dealing with database or log files or creating/manipulating any login/user. I am looking for any way to generate T-SQL code for such actions, so that it may be kept for later reference

© SQL Server Central or respective owner