Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 how to check the daily database changes for auser

Author  Topic 

prakash t soundappan
Starting Member

3 Posts

Posted - 2013-05-28 : 07:21:09
hi everyone,
i want to check all the changes made by various users in database yesterday(daily basis),like procedures,triggers,functions and table changes.i want to check all the changes for yesterday on today and tomorrows changes on the day after tomorrow like that.i also want their user name and time of changing it.


can any one help me.

thanking you in advance,
prakash

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-28 : 07:44:52
do you've audting or change tracking enabled in the db?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

prakash t soundappan
Starting Member

3 Posts

Posted - 2013-05-28 : 09:17:09
quote:
Originally posted by visakh16

do you've audting or change tracking enabled in the db?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




we have nearly 30 databases with various users in all the database but same admin for all the database.
we dont have auditing or change tracking enabled in our databases.we are looking for a process that allows users to change the database objects and attributes without any restriction and at the same time the changes to be indicated to the admin when he is checking for it ....

thanking you in advance,
prakash
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-28 : 14:27:20
you need to have either of the options enabled or atleast have custom logic using triggers if you want to capture this. Alternatively you could capture trace using profiler too.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-05-29 : 10:48:05
Audit trace would help. There are third party applications that will do this. For PCI compliance we are using Idera compliance manager that tells use who changed what object.

djj
Go to Top of Page

prakash t soundappan
Starting Member

3 Posts

Posted - 2013-05-30 : 08:38:11
quote:
Originally posted by visakh16

you need to have either of the options enabled or atleast have custom logic using triggers if you want to capture this. Alternatively you could capture trace using profiler too.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs





thank you i have enabled both change tracker and profiler it is fine to track each user thank you for helping me . it made my work easier....

thanking you in advance,
prakash
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-31 : 02:29:51
welcome



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -