hi,

This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. so i don't know why you are going to use a feature which is going to be desupported.

bryan

here are a few examples if you still want to user this feature:

http://ashwaniroy.spaces.live.com/blog/cns!B805C4EB6ABB1C00!264.entry?wa=wsignin1.0&sa=45787967

http://www.virtualobjectives.com.au/sqlserver/logins_audit.htm