Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

audit object changes

Status
Not open for further replies.
vadimg

vadimg

IS-IT--Management
Oct 25, 2001
152
US
hi.
i know this has been discussed before, but i can't find it.

What is a good way to track object changes (tables, sps, constraints, etc). Can't have a trigger on system tables so that's not an option.

does anyone currently do this?

Thanks!
 
Sort by date Sort by votes
Make the developers use Visual Source Safe and only the DBA's have access to alter/create objects.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Upvote 0 Downvote
ahem... thanks ;0)

should i read this 'no there is no good way to audit trail object changes'?



 
Upvote 0 Downvote
Yeah pretty much. You could write something that pulls the data from the system tables into tables in a database, and compair the new records with the old versions.

I started working on something like that at my old job, but never got it finished.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Get Min and Max Time until it changes - Please Help 1
Replies
7
Views
230
bborissov
bborissov
BxWill
  • Locked
  • Question
TSQL - Create Foreign Keys - Error: There is already an object named FK_EquipMaster" 2
Replies
8
Views
592
Olaf Doschke
Olaf Doschke
Cpreston
  • Locked
  • Question
Coding Issue changes required 1
Replies
4
Views
200
dhookom
dhookom
DougP
  • Locked
  • Question
SSMS 2014 bug not freshing to see new changes made to tables or otherwise
Replies
2
Views
189
philhege
philhege
sugarflux
  • Locked
  • Question
Could not allocate space for object [INDEX] 1
Replies
8
Views
513
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top