August 20, 2003 at 2:10 pm
Anyone know of a quick way to track structural changes to a table?
Aurora
August 20, 2003 at 2:12 pm
Put copies of table schema mod scripts in SourceSafe or CVS. Enterprise Manager allows you to save a change script through the Table Designer interface if you prefer the graphical approach to table modification.
August 21, 2003 at 1:54 am
Hi there
I'm by no means a guru, but have thought about this issue myself recently. Haven't done it yet, but maybe my initial train of thought might help you in a way.
I thought of 1) creating a permanent table storing the relevant information from sysobjects, syscolumns and sysindexes of the table object I'm interesting in auditing.
Then I would 2) write a stored procedure to read the current information into a table variable or temp table and use a script I found here on this site to compare the data in two tables to highlight or record any differences.
Only problem with this is that you DON'T have the username that changed the table and that you have to run the script manually or through a scheduled job once or more per day to track changes. But what else do you do if you can't have triggers on system tables???
Sorry if this doesn't help you in ANY way, but maybe someone else there will come up with the solution and I might benefit from it as well
Nikki Pratt
Development DBA
Nikki Pratt
Development DBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply