Month: September 2016

ScriptOut Change Tracking Tables

ScriptOut Change Tracking Tables SELECT sys.schemas.name AS Schema_name , sys.tables.name AS Table_name , ‘ALTER TABLE ‘ + QUOTENAME(sys.schemas.name) + ‘.’ + QUOTENAME(sys.tables.name) + ‘ 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

Top