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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-28 : 07:23:09
|
| eleni writes "Help!!!How can I monitor if the changes in a table in SQL Server(like adding columns) has been done by design table in enterprise manager or by running a patch program that runs sql commands?Please help" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-28 : 07:28:06
|
| There is no difference between the way Enterprise manager create/alters table and script used for that. Ultimately it boils to CREATE/ALTER table command (although EM is bad performance-wise).Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-28 : 08:23:55
|
| We have a "Script Logging Table" and at the top of every script we write we put something like:INSERT INTO MyScriptLoggingTable(ScriptName, ScriptVersion, RunDate) ...so that we know what scripts were run, in what order, and on what date. The Version Control system we use would enable us to review the contents of a script as-it-was at the time it was run.Anything else was caused by something else!Kristen |
|
|
|
|
|
|
audit table changes in columns