InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 13:38:46 GMT20http://www.sqlservercentral.com/Forums/Topic826017-391-1.aspx[quote][b]samsql (11/29/2009)[/b][hr]Hi all,we are useing sqlserver 2008i have one login dttl has sysadmin rights for which i want to enable audit log for every thing which is done by this useri dont want to enable it for all the logins thankz[/quote]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_createsp_trace_seteventsp_trace_setstatusCEWIIMon, 07 Dec 2009 18:52:10 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic826017-391-1.aspxYou 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: [url]http://msdn.microsoft.com/en-us/library/dd392015.aspx[/url]Mon, 30 Nov 2009 10:20:47 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic826017-391-1.aspxwaiting for the revert please reply....Mon, 30 Nov 2009 03:39:33 GMTsamsqlhttp://www.sqlservercentral.com/Forums/Topic826017-391-1.aspxHi all,we are useing sqlserver 2008i have one login dttl has sysadmin rights for which i want to enable audit log for every thing which is done by this useri dont want to enable it for all the logins thankzSun, 29 Nov 2009 23:16:17 GMTsamsql