MS SQL Server - include login or workstation id in permission denied alert

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

include login or workstation id in permission denied alert

sqlgirl

2006-03-10, 1:23 pm

Hello,
I am a DBA for SQL 2K sp4 environment
I have setup a SQL Server evetn alert for error 229 so that I get an email
when someone tries to access an object they should not have.
Is there a way to add either a login or workstation to this error or alert
so that I know who the persion is that is trying to acces the objects?

Thanks in advance..

Sponsored Links