Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Audit Expand / Collapse
Author
Message
Posted Sunday, November 29, 2009 11:16 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:30 PM
Points: 313, Visits: 537
Hi all,

we are useing sqlserver 2008


i have one login dttl has sysadmin rights for which i want to enable audit log for every thing which is done by this user
i dont want to enable it for all the logins

thankz
Post #826017
Posted Monday, November 30, 2009 3:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 6:30 PM
Points: 313, Visits: 537
waiting for the revert please reply....
Post #826100
Posted Monday, November 30, 2009 10:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
You can set up a trace for this and filter it by selected logins. Or you might be able to use the SQL 2008 audit feature: http://msdn.microsoft.com/en-us/library/dd392015.aspx






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #826352
Posted Monday, December 7, 2009 6:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
samsql (11/29/2009)
Hi all,
we are useing sqlserver 2008
i have one login dttl has sysadmin rights for which i want to enable audit log for every thing which is done by this user
i dont want to enable it for all the logins
thankz

Depending on what version of SQL 2008 you are using depends on whether you'll be able to use Steve's suggestion. Only Enterprise (and developer) have the audit features. Otherwise you could setup a server side trace and set a filter on that user alone. You can set it to trace any events you want.

You might look into these commands:
sp_trace_create
sp_trace_setevent
sp_trace_setstatus

CEWII
Post #830359
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse