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

Logins Expand / Collapse
Author
Message
Posted Wednesday, December 17, 2008 11:54 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:33 AM
Points: 49, Visits: 399
I have a task in where I need to know what user activity was done in past 1 week or later ...

Or you can say A user logged in yesterday and deleted some data or did some insertion or soemthing etc etc how would I know is it stored in any table or is there any system functions which can tell me what a user activity was did yesterday......

I hope you all understand my question....

I know the above can be achieved by placing triggers on tables but i dont want to put a trigger .....


thanks
Post #621808
Posted Thursday, December 18, 2008 1:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 27, 2014 8:18 AM
Points: 2,404, Visits: 2,940
SQL does not keep track of user actions. You can monitor this by setting up a trace with SQL Profiler and filter on the specified user. But be aware that this trace can get large proportions (depending on what you log and how heavy your db is used).

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #621838
Posted Thursday, December 18, 2008 1:31 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 7:41 AM
Points: 323, Visits: 464
U can make DDL trigger to trackout DML changes from user.
and make DDL trigger to trackout DDL Trigger for structure change.



_____________________________________________________________________________________________________________
Paresh Prajapati
+919924626601
http://paresh-sqldba.blogspot.com/
LinkedIn | Tweet Me | FaceBook | Brijj
Post #621844
Posted Thursday, December 18, 2008 8:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:33 AM
Points: 49, Visits: 399
My question is i need to track a user activity which was done in past (Yesterday) and i dont want put any trigger or so...
Post #622188
Posted Thursday, December 18, 2008 11:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:10 PM
Points: 1,414, Visits: 4,541
run the session and the other system view whose name i can't remember but it's not requests

i have a join and dump the data into a table and check it once in a while


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #622359
Posted Friday, December 19, 2008 2:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 7:45 AM
Points: 968, Visits: 971
I don't think you'll be able to obtain the data you're looking for because SQL doesn't keep track of that out of the box. As others suggested, you'd need to set up a trigger to log that activity going forward, but its not possible to see who deleted or modified data yesterday.
Post #622693
Posted Friday, December 19, 2008 9:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:33 AM
Points: 49, Visits: 399
Well its so strange that we cant keep a track who did what on yesterday as i said i am not suppose to have a trigger .....

Thanks for all your help and answers
Post #623104
Posted Friday, December 19, 2008 9:32 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:10 PM
Points: 1,414, Visits: 4,541
you can audit SQL, it's just not set up by default because not everyone needs it and everyone doesn't want to put up with the overhead and it requires a lot of customization

all of our triggers go thorugh QA for performance testing first


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #623119
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse