| Thread | Last Post | Replies |
|
| Merge replication error | 12 Jul 2008 00:00 GMT | 3 |
Hi SQL server experts, I created a simple table called test2 which only has one int column on both publication db and subscriber DB. I then created merge publication and subscription for this table.
|
| Replication with SQL 2005 Standard | 11 Jul 2008 21:02 GMT | 4 |
I'm trying to validate what I've been told, and after going through many posts, I think things are close to be squared out but I need to make sure. We have a web server in the DMZ running custom .NET applications and a SQL 2005 standard on the internal network. We need something ...
|
| INSERT THROUGH SSIS | 11 Jul 2008 16:07 GMT | 1 |
Dear Professional, I want to ask one quick thing regarding data Insert through SSIS Package. Daily I insert 10000 records through SSIS Package into one of the table. Now the problem is data is not replication into Subscriber, is there any way
|
| PULL Subscription in SQL 2005 | 10 Jul 2008 22:56 GMT | 3 |
I have couple of questions and appreciate if some body can answer 1. In case of SQL 2000 once we click on replication thru EM ,it shows all 3 agents on right side and shows it is PULL or PUSH ,but where i can find the same in SQL 2005 to see if the subscription is PULL or PUSH?
|
| identity column in Merge replication. | 10 Jul 2008 21:30 GMT | 1 |
I need to replicate a table with a identity column as the primary key. I would like the two tables (publisher side and subscriber side) to have different seeds. The problem is: If I choose to initialize during the creation of the
|
| adding new subscriber to existing replication | 08 Jul 2008 13:08 GMT | 3 |
We have replication setup already (bi-directional). How can I add JUST a "subscriber" to the replication? I want to do this with T-SQL. There does not seem to be any documentation that says "here are the
|
| What can be the source for replication? | 07 Jul 2008 14:24 GMT | 1 |
Is SQL Server limited to replicating only from Oracle and another SQL Server or I can somehow replicate from some other ODBC database? //Misha
|
| Identity ranges lost during failed synchronization | 03 Jul 2008 16:41 GMT | 2 |
I've run into a problem with SQL Server replication and really need some help. Background ---------- We are using Merge Replication with SQL Server 2005 Enterprise edition at
|
| Need to take down a dedicated distributor SQL 2005 server for maintenance window | 03 Jul 2008 16:24 GMT | 1 |
My ops team is going to move the physical storage of our SAN into a different rack. They will be powering down my dedicated distributor, used for brokering transactional replication w/ Push subscriptions from one publisher.
|
| Connecting to subscriber instance via business logic handler... | 03 Jul 2008 15:12 GMT | 1 |
I have a customer resolver for replication where I am trying to open up a connection to the subscriber to execute stored procedures when synchronizing the data. This seems to work well with a LAN configuration, but when it is
|
| replication error "memory mapped file read failed" | 03 Jul 2008 03:24 GMT | 5 |
Hi gurus, My replication has an error which I cannot solve for the whole day Environment: SQL Server 2K5 EE (CU8) + Window 2k3 (SP1)
|
| Orphaned subscription | 02 Jul 2008 17:01 GMT | 2 |
We had a pull subscription set up between two SQL 2005 servers at different sites, (SP2, v. 9.0.3161). Somehow, the subscription record was deleted at the Subscriber, but still remains at the Publisher. Attempting to delete it just seems to lock up the Managment Studio, through ...
|
| Will moving tempdb affect replication | 02 Jul 2008 16:29 GMT | 1 |
I would like to move the location of tempdb but I am not sure if this will affect replication. I know it requires a SQL restart but will replication need to be setup again? thanks....
|
| does distribution db hit a lot during merge distribution? | 02 Jul 2008 10:41 GMT | 1 |
does anybody know if distribution db is really hit hard during merge replication? I am under impression that it holds agent history and metadata. But it does not hold actual copies of rows flowing back and forth.
|
| Adding 3rd server to bi-directional replication configuration | 01 Jul 2008 12:08 GMT | 1 |
I have 2 servers that fully replicate a large database -- it comprises of a number of publications (each with a few articles). This works perfectly. I want to introduce a third server. This server will subscribe to a
|