Should I fix this and if so how? USE MASTER SELECT sysdatabases.name , sysdatabases.filename AS [sysdatabases.name] , sysaltfiles.filename...
Does anyone have an opinion on specific “data comparison tools� We are looking for something to use in our test or dev environments that will...
How do I get the EventInfo value from dbcc inputbuffer into @EventInfo ? DECLARE @spid int DECLARE @EventInfo nvarchar(255) SELECT [USER_NAME()]...
What can be done to have a trigger return the SqlCommand or sql statements responsible for the change? I am using app_name() and host_name() and am...
Need to capture start/end datetime, user name and stored procedure name for every time any non-system stored procedure runs for a specific DB on a...
Separate names with a comma.
