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