Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Management Studio (SSMS) Rss

   Items 1 to 2 of 2   
 

Get script for every action in SQL Server Management Studio

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  Read more...
By Additional Articles 2010/12/20 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 4,132 reads

Creating a Maintenance Plan in SSMS - SQL School Video

Maintaining your database server is something every DBA or developer needs to do. This video shows how to setup a basic maintenance plan.  Read more...
By Brian Knight 2008/11/11 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,095 reads
   Items 1 to 2 of 2   
 
Tags
maintenance plans (1)    
video (1)