It's good to have different platforms to allow comparisons. Are both your production/QA and development machines on the same version of SQL Server? Were there any variations in...

Is there a concern regarding network latency in merge replication?

And your question is? What does the error message mean? Where do you specify the setting in question? Is this a problem?

As a general rule,...

OK. I think I solved this - by increasing the 'magical' powers of the DRsql user ID, I managed to make the assignments work. It's not clear to...

(Shameless bump, adding more details)

My objective is to take a 'copy' of a production database and copy it to an offsite location several hundred miles away. My plan was...

Depends on the type of replication. Also on what size your database is. I assume it's inconveniently large, true? ALso, what version of ss? what...

WOW! It's not often I get to learn as much from the comments as from the article which originated the comments! Of course, I'm at that stage where...

Steve Jones - Editor (8/1/2008)

---

We re-run older, popular articles at times. With nearly 200,000 people joining the site in the last year, it's not "old" to them, it's likely the...

Please elaborate. change collation of table and rows separately from what? each other? or general, overall database?

btw,...

The 'strict' answer to your question is that SQL Server CAN be case sensitive, depending on the collation. Hence the above question. BOL will define the various collations...

What kind of app are you running? It's possible that your app is hard coded for a different instance (bad programming? that's another thread...). If the app is...

When, then, is an appropriate use of sp_repldone?

Just because your database is a subscriber is no reason NOT to have proper maintenance plans in place. If you're not doing anything with your transaction logs, then the...

I assume you 'inherited' this database, rather than authoring it. I'd suspect that someone, before you, set the TempDB to start at 12 GB. Either that or you...

Define your frequency of 'synchronization' requirement. Also, depends on the size of your database. Sounds like you really want merge replication, based on what little you've said. ...