Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-10-03 : 09:47:16
|
| I'm having a brain cramp. I don't recall what I need to do to capture Error 229: %ls Permission Denied... in a profiler trace. This works for me on one of our server, but I believe I had to do something initially that told SQL Server to write either Error 229 or all Severity 14 errors to the SQL Server Error Log. Do you know what needs to be done to trace this error or write this error to the error log?Thanks, Dave |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-10-03 : 10:11:06
|
| Nevermind. EXEC sp_altermessage 229, 'WITH_LOG', 'true' |
 |
|
|
|
|
|
How to capture Permission Denied in Profiler Trace