BOL states that the only editions of SQL Server 2000 than can run on Win98 are Personal and Desktop (MSDE 2.0).

The only editions of SQL Server 7.0 that can run...

The ctsv_... is a view. One is created for each table in the publication. It is supposed to be created by the initial snapshot job, along with the...

All editions of SQL Server support replication, even MSDE, which is free since you already have a full SQL Server license. But...to use MSDE 1.0 (same as SQL Server...

BOL states that the column must either allow NULLS or have a default value. It is just enforcing the implicit contraint for existing rows (either has to have a...

I would think they would be equal since the getdate functions should be evaluated during the "compiling" of the query. But to be sure, I would create a variable...

I don't have access to a NT machine right now, but check the switches for the del command (del /?). NT has most of the same switch options as...

In response to your second question, you need to use different identity ranges on each server, so that there will never be "duplicate" IDs. Search for "Managing Identity Values"...

Hmm. I understand that rationale when used in context of enforcing contraints. But this was caused by an error. Either way though, the process should notify the original...

You need to use the trigger_nestlevel() function to either test if your trigger is already running, or if the replication trigger is running, or has run. There's several ways...

No, MSDE 1.0 (SQL 7) subscribers will not work with publishers that are licensed in per server mode. It's just a licensing thing that they put in there to...

If you haven't done so already, run the "Configure Publishing, Subscribers, and Distribution..." wizard in EM for your database. This will ensure that everything is configured correctly, including the...

Yes, it's a huge range. If I ever have to assign a new range, I'd do it during one of the reinitializations by recreating the tables. But I...

Actually, I am NOT using 'Auto Range Management' because of the problems I mentioned. I assigned the ranges to each subscriber manually (well, sort of - I built a...

quote:

---

Thanks, I'd be interested to see how you implemented it. If I understood you correctly, you have a script that you...

I had a similar but different problem with merge replication. I have a central publisher and a couple dozen subscribers. I tried letting replication manage the identity ranges,...