 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008Table schema change
Hi, I need to monitor sql db table schema change. is there any system tables taht I could use to see any schema changes? Thanks, You could create a DDL trigger for all table changes: http://msdn.microsoft.com/en-us/library/ms189799.aspx  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau Hi, I need to monitor sql db table schema change. is there any system tables taht I could use to see any schema changes? Thanks, Thanks for the respose. It means that I have to create triggers for all tables in the DB? > You could create a DDL trigger for all table changes: > [quoted text clipped - 4 lines] > > Thanks, > Thanks for the respose. It means that I have to create triggers for all > tables in the DB? No, a DDL trigger is not table-specific. You should be able to create a single trigger at the database level to capture all or specific DDL events (e.g. ALTER TABLE). got it, thanks a lot >> Thanks for the respose. It means that I have to create triggers for all >> tables in the DB? > > No, a DDL trigger is not table-specific. You should be able to create a > single trigger at the database level to capture all or specific DDL events > (e.g. ALTER TABLE). Sorry, I just noticed that DDL triggers are only support sql2005. We are using sql2000. >> Thanks for the respose. It means that I have to create triggers for all >> tables in the DB? > > No, a DDL trigger is not table-specific. You should be able to create a > single trigger at the database level to capture all or specific DDL events > (e.g. ALTER TABLE). In future, please state which version you are using, particularly if it is not the current version. In SQL 2000, there is no way of capturing DDL events, other than running the profiler. SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau Sorry, I just noticed that DDL triggers are only support sql2005. We are using sql2000. >> Thanks for the respose. It means that I have to create triggers for all >> tables in the DB? > > No, a DDL trigger is not table-specific. You should be able to create a > single trigger at the database level to capture all or specific DDL events > (e.g. ALTER TABLE). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.