Thank You very much Bhuvnesh.Just to clarify,Is there any other option in sqlserver to track this(other then trace and c2 audit,since this may low down the system performance).I just want...

..

Guys,

Can someone give me a script that fires a trigger whenever sysadmin access is granted to a builin\adminstrator login.

Many thanks,

Boj

Guys,

Can someone give me a script that fires a trigger whenever sysadmin access is granted to a builin\adminstrator login.

Many thanks,

Boj

Guys,

Can someone give me a script that fires a trigger whenever sysadmin access is granted to a perticular login.

Many thanks,

Boj