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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2005-03-07 : 16:46:38
|
| Hello All - Please let me know if there's a topic about this same issue.AuditingIs that possible to make the Server send me a notification of each/any change made to the schema of any DBs (Or DBs I select) ? I wonder if there isn't a stored procedure for that...Thanks in advanced!IgorblackbeltI Love Challenges! That's why I love coding! |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-03-07 : 16:57:59
|
| There isn't a good way to do that now, you are better off enforcing it via some work procedures.On my team, everyone develops locally, if they need to make a schema change, they create a patch script and check it into CVS. From there it gets deployed to the staging servers for testing etc, then to live when it's ready.It's fairly easy to enforce, just tell people their code doesn't exist, and is likely to get wiped unless it's in CVS.Damian |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Database Changes