December 17, 2008 at 11:46 am
Hi all,
I'm running into Level17 and Level19 errors when those have never been popping up in the past. I know that I haven't made any major changes to SQL Server and to be safe, I rolled back the changes that I did make to be sure those changes weren't the cause of the errors.
The errors are still popping up and the unique piece of this puzzle is a lack of transparency and openness. I have a supervisor that does things on his own and refuses to keep anyone in the loop. Furthermore, when I ask questions, I don't feel like I get straight answers.
So, the only way I'm going to know if something changes that I don't do (yes, I document my work) is if I audit all activity on the server.
Does anyone know of an efficient way to do this? Any help at all is greatly appreciated.
Thank you so much in advance.
December 17, 2008 at 12:24 pm
for DDL.
from SSMS right click on db and select schema history changes report.
December 17, 2008 at 4:11 pm
You might also want to try:
fn_trace_gettable
as:
SELECT *
FROM fn_trace_gettable
('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default)
The location above is the default location for traces, yours may have been altered.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply