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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Would I break replication here?

Author  Topic 

SQLTim
Starting Member

21 Posts

Posted - 2006-04-06 : 14:47:45
In place is one way replication from Production server to reporting server.
We want to modify an index manually in both places.

Does anyone see a problem with this?

Thanks in advance!!
Tim

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-06 : 15:44:37
Nope. I've done it numerous times.
Tara Kizer
aka tduggan
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-07 : 00:06:04
nope, something to look out, if you have snapshot drop the tables instead of just deleting the records, expect these indexes will be dropped also plus you'll get the same indexes from production if they're set to be replicated also

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -