Month: September 2016

ScriptOut Change Tracking Tables

ScriptOut Change Tracking Tables SELECT AS Schema_name , AS Table_name , ‘ALTER TABLE ‘ + QUOTENAME( + ‘.’ + QUOTENAME( + ‘ ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON) ‘ + CHAR(13) AS SQLScript FROM sys.change_tracking_tables JOIN sys.tables ON

How to become DBA favorite Developer

Application Name : When a connection is made to SQL Server there are by default no way for SQL Server to know what software is making the connection. If several apps are using a shared SQL Server and there are