November 29, 2009 at 11:16 pm
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
November 30, 2009 at 3:39 am
waiting for the revert please reply....
November 30, 2009 at 10:20 am
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
December 7, 2009 at 6:52 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply