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 |
|
panthagani
Yak Posting Veteran
58 Posts |
 Posted - 2008-06-02 : 04:57:32
|
| I have a database configured for transactional replication. It seems that there are frequent schema changes on one of the subscribers. Suddenly, I start getting some DB related errors on the application's client UI (that I use). Upon investigation, I found that the schema of some of the table(s) in the subscriber has changed.Is there a way to find out what is causing this change?Thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-02 : 06:04:59
|
| You could create DDL triggers on the table which would help you to capture details of who is causing the changes. But the presence of DDL triggers may have an impact on performance of db. How frequently does changes happen on your tables? |
 |
|
|
panthagani
Yak Posting Veteran
58 Posts |
Posted - 2008-06-02 : 07:00:08
|
| Thank you for the input. It occurs with tables at random. Atleast that's what I found in the last 3 occurences. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-02 : 08:34:18
|
| DDL triggers are not supported in SQL 2000. If your subscribers changes often , you can add column and reinitialize subscriber. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 20:04:37
|
| Check Idera, they have free schema change monitoring tool. |
|
|
|
|
|
|
Frequent schema changes in SQL 2000?