SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Audit

Audit Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
samsql
Posted Sunday, November 29, 2009 11:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 11, 2010 3:35 AM
Points: 225, Visits: 413
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
samsql
Posted Monday, November 30, 2009 3:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 11, 2010 3:35 AM
Points: 225, Visits: 413
waiting for the revert please reply....
Post #826100
Steve Jones - Editor
Posted Monday, November 30, 2009 10:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: Administrators
Last Login: Today @ 5:02 PM
Points: 23,164, Visits: 6,924
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
Post #826352
Elliott W
Posted Monday, December 07, 2009 6:52 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 2,406, Visits: 1,869
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

--------------------------------
Having trouble figuring out what jobs are running in SQL Server at the same time.
Try Sql Job History Visualization
It lets you view your SQL Job history on an Outlook style calendar..
Post #830359
« Prev Topic | Next Topic »


Permissions Expand / Collapse

 
 
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use