Script Title:

Please Select a Script Title? ALL DATABASE COLLATIONS Backup All Databases Backup All databases with WaitFor and Verify Check SQL Server Error Log Database Mail Configuration (TSQL) Database owner script Database Recovery Models DBA_BACKUP_ALL_DATABASES DBA_DatabaseInfo DBA_DISKSPACE_GATHERING DBA_FAILOVER_ALL_MIRRORING DBA_GRANT_EXECUTE DBA_LOGSPACE_GATHERING DBA_MIRROR_MONITOR DBA_Pause_All_Mirroring DBA_POLICE TRIGGER (Server) DBA_Police_Trigger (Database) DBA_RESUME_ALL_MIRRORING DBA_SetEmailOperatorForAllJobs DBA_SQL_LOG_GATHERING DBA_SQL2008_Compression DBA_UPDATESTATS DBManagement Database Growth Query - Single Database DBManagement Database Growth Report DBManagement Disk Space Send Mail DBManagement Installation Enable database mail Enable OLE Automation Enambe xp_cmdshell Gather database level Info Get details of the last backup Identify Blocked SPIDs Insert Into Where Not In Example IOPS Get Avg Read Writes Per Sec List all AD Groups and Users List all tables within a database together with size and number of rows Monitor database growth using the MSDB database os_wait_stats Profiler SP Durations Query System Stats Re map orphaned database users Read registry using TSQL Reporting Services - Remove detailed header Run all TSQL scripts in a directory Script Timing Search SQL Server Agent Job Steps for Specific Keyword Text or Stored Procedure Server Level Info Show Fragmented Index dm_db_index_physical_stats Shrink a Mirrired Database SQL Server Agent job details SQL Server Audit SQL Server Port Number (TSQL) SQL Server Version Check Stored Proc Durations TSQL Move TempDB example TSQL Restore Example TSQL WaitFor Useful DMV's

Search String:

Add a New Script