Tag Info

New answers tagged


You should be able to locate this within the default trace for SQL Server, if it is still enabled on the instance. One of the events captured is the Security Audit: Audit DBCC Event, can read more on the event here. If you find the default trace is enabled the following query from MSSQLTips.com article to find when DBCC were executed: DECLARE @path ...


Well, you should be able to fix his procedure with a very simple change. Change this line: SELECT @dbccPageString = 'DBCC PAGE (' + @dbName + ', ' To this: SELECT @dbccPageString = 'DBCC PAGE (' + QUOTENAME(@dbName) + ', ' But really, fix your database names. This is not the last thing that will break as a result.

Top 50 recent answers are included