dbcc auditevent

[masds]

Who knows this command? I try to write something that can use the inforamtion from error log, I guess I can use this command. Thanks

 

[SQLBill]

Where did you find that command at? It's not in the BOL.

-SQLBill

Posting advice: FAQ481-4875

 

[masds]

I try to customize sp_password and look it's code, the command is there, I don't know what it is supposed to do.

 

[JayKusch]

That is a VERY obsure DBCC command. All I could find was its syntax as passed params ...


DBCC auditevent
(eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)


I delve a bit deeper in MS archives for more info.

Thanks

J. Kusch

 

[SQLBill]

I couldn't even find it in the Guru's Guide to Transact SQL by Ken Henderson which is an excellent book for undocumented procedures, DBCC commands, etc.

-SQLBill

Posting advice: FAQ481-4875