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 sys.tables.object_id = sys.change_tracking_tables.object_id JOIN sys.schemas …
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 problems caused by a certain …