I\'ve been trying, googling and hitting my head against the wall but can\'t figure our what the problem is or how to solve it.
Running SQL 2008... Where can I find in the SQL dB or how can I determine if a transac开发者_JAVA百科tional subscription was initialized when it was created??
I am trying to implement a transactional replication in 2008. Both the publisher and subscriber are in 2008 version.So far so good.
I need to make structure changes to a database that is part of a subscription that is using Transactional Replication.
Transactional replication from SQL 2005 into SQL 2008r2.CDC established on SQL 2008r2 side.Each day, from 2 to 4 of these tables lose their CDC settings (ie. is_tracked_by_cdc in sys.tables moves from
Does anyone know of the correct stored procedure that validates the actual code in transactional replication?I have a view that basically is a select * from table1.I changed that view to select * from
I have a situation where I use SQL server transactional replication from my main database 开发者_如何学Pythonto my failover database. I have a main site and my fail over website is using my failover d
Is it possible to replicate a CLR Function using Transact开发者_JAVA百科ional (or Merge) Replication?Yes. See: Publishing Data and Database Objects
I have setup SQL Server transactional replication to run continuously for two tables (Parent and child records). At the subscriber end, I have insert and update triggers on both replicated tables.
I\'ve \"inherited\" a working Oracle (10g) to SQL Server 2005 data replication using standard SQL Server snapshot and transactional replication.