SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logins


Logins

Author
Message
Dreamsz
Dreamsz
SSC-Enthusiastic
SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)

Group: General Forum Members
Points: 183 Visits: 593
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
HanShi
HanShi
SSCrazy Eights
SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)

Group: General Forum Members
Points: 9062 Visits: 3718
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’! **
Paresh Prajapati
Paresh Prajapati
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2065 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
Arrow +919924626601
http://paresh-sqldba.blogspot.com/
LinkedIn | Tweet Me | FaceBook | Brijj
Dreamsz
Dreamsz
SSC-Enthusiastic
SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)

Group: General Forum Members
Points: 183 Visits: 593
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...
alen teplitsky
alen teplitsky
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7482 Visits: 4674
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
S. Kusen
S. Kusen
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3111 Visits: 1124
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.
Dreamsz
Dreamsz
SSC-Enthusiastic
SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)

Group: General Forum Members
Points: 183 Visits: 593
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
alen teplitsky
alen teplitsky
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7482 Visits: 4674
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search