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 |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2004-10-12 : 15:26:14
|
I tried searching the articles but kept timing out...How can I track object changes in my database...I have a development team and they may make changes in the dev environment I would like to generate an audit trail of who made the changes so I can follow up with them, as well as balance my workload for moving those changes into production. |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-10-13 : 01:10:26
|
| did you mean table/view changes or stored proc changes?I prefer my developers not make and table/view changes. I'd have it done thru a single point of control (usually a DBA) where it can be tracked by any modelling tool.SPs can be tracked by implementing any version control tools.Hemanth GorijalaBI Architect / DBA...Exchange a Dollar, we still have one each.Exchange an idea, we have TWO each. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-13 : 01:29:30
|
| http://www.nigelrivett.net/DMOScriptAllDatabases.htmlKristen |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-10-13 : 16:46:46
|
| Kristen...Hey that is exactly what I was looking for, as far as changes go...I guess the only piece I would be missing is the who... Which I can deal with in meeting where appropriate.Thank you again this will help me in my new assignment where they have been without a dba for the past eight months and I can only imagine what I will have to contend with. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-14 : 04:01:25
|
| Hey no worries, but its Nigel you should be thanking ... he's around these parts ...Kristen |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-10-14 : 15:40:57
|
| Kudo's Nigel... Thank you for the Blog |
|
|
|
|
|
|
Tracking Db Changes