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.
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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 MVPhttp://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 |
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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 |
|
|
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 MVPhttp://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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-31 : 02:29:51
|
welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|