| Thread | Last Post | Replies |
|
| Microsoft Class 2591 | 30 Jul 2005 23:40 GMT | 2 |
I was wondering if any has taken the Microsoft course on Replication? I need to give a two day tutorial to some of the poeple I work with in Operations on Replication and came across the course outline for this class. The outline was perfect - I could eliminate some of the modules ...
|
| Snapshot generation: Error number: 2705 | 30 Jul 2005 11:26 GMT | 1 |
hi all...new to replication and 1st post here ....looking to replicate our database and having trouble with one table. i recreated the table in northwind to isolate it from the rest of the DB tables in the app. Same result.
|
| MSDE 2K Merge replication without network | 30 Jul 2005 11:22 GMT | 2 |
I'm new to replication, but have a challenging requirement... I have multiple MSDE 2K instances that will be used by a surveying crew that may be distributed across many miles - sometimes in jungle or desert environments where they never even see each other.
|
| Blocked table | 30 Jul 2005 11:20 GMT | 1 |
I have a merge sinchronization working just fine. And I have a table sinchronizing a long time ago without data because i was not using it yet. No that I have decided to use it, it always said that I can't insert Null in the rouguid column.
|
| Can't drop a table | 30 Jul 2005 11:19 GMT | 2 |
I have a table that used to be in a merge replication. How ever it is not being replicated any more, I can't drop it because it thinks it is been replicated. How can I drop it? Thanks a lot, Lina
|
| ODBC Error:Cannot generate SSPI context? | 30 Jul 2005 11:15 GMT | 1 |
From time to time (about once a day, and it lasted about 2 minutes), the following error happened: DESCRIPTION: Error: 14151, Severity: 18, State: 1 Replication-Replication Transaction Queue Reader Subsystem: agent [MYDB].12
|
| Can't setup replication | 29 Jul 2005 23:42 GMT | 4 |
Initially, when I started to setup replication I received the error message ~ "one or more articles are published ...", so I issued the following commands to remove replication settings from the DB: sp_configure 'allow',1
|
| Changing sql dbo user password (will this effect current replication) | 29 Jul 2005 21:48 GMT | 2 |
We have a subscriber that want's to change the dbo password for the replication user. Will this effect current publications to that subscriber? tia
|
| Initially merging two databases | 29 Jul 2005 16:07 GMT | 2 |
This is probably a newbie question but I was wondering if there is a way to setup the initial snapshot between two databases, that are the exact same database, and merge the data between the two without losing or overwriting any data? It seems that "Merge" is the way to go ...
|
| Transactional Replication and Text Data Type | 29 Jul 2005 15:50 GMT | 3 |
I have just discovered that subscribers in transactional replication with immediate or queued updating cannot update text columns. : "INSERT, UPDATE, and DELETE statements at the Publisher on text and image columns are supported with no special considerations. However, these ...
|
| NOT FOR REPLICATION | 29 Jul 2005 04:26 GMT | 3 |
Could anyone explain to me under the relationship property, what is the meaning of "Enforce relationship for replication"? I understand that the "Not for Replication" in Trigger is that the trigger won't get fired off if the data is Insert/Update/Delete during the
|
| sql server 6.5 restoration | 28 Jul 2005 21:05 GMT | 1 |
hello all i have a huge problem. My server crashed i had to reinstall windows nt and sql server 6.5.my buckup is 2 weeks old and i dond want to lose my db, i have all the file when it crashed from the directory MSSQL. Is it possible to restore my db using the master.dat or ...
|
| alter replication triggers | 28 Jul 2005 21:03 GMT | 1 |
I have a customer application where I utilize merge replication between sqlserver2000 and pocketpc's that are running sqlserverce2.0 (vb.net 2003). It appears that the customer has some tables that they use to keep track of who modifies the data in certain tables. they want the same ...
|
| Replication problems after SP4 upgrade | 28 Jul 2005 15:21 GMT | 4 |
We're experiencing a problem with transaction replication on SP4. The snapshot is taken without any problems and applies, however, when it comes to processing the additional transactions which have taken place since the snaphot, the process starts processing in parrallel and ...
|
| Performance hit on subscribers under merge replication | 27 Jul 2005 09:19 GMT | 14 |
I have a setup where a single 1.5 million row table is published to 6 separate databases using merge replication. On 4 out of the 6 I have no problem, but on 2 there seems to be an excessive performance hit on the subscribing server's CPU when the distributor attempts to apply ...
|