Is the "allow_initialize_from_backup" option set on the publisher and distributor DBs? If you run sp_helppublication on the publisher DB does the column "allow_initialize_from_backup" in the results of this SP have...

Statistics don't get pushed over to the subscriber in transactional replication - you'll need to manage statistics (and indexes) on the subscriber.

I wouldn't recommend "testing" this in your production environment - test it out in any other environment (dev or test environments) to ensure that the alerts have been configured properly...

This http://msdn.microsoft.com/en-us/library/ee523927.aspx is a good resource that provides a whole bunch of HA planning and implementation information (covering replication, mirroring, log shipping etc)

From the distribution agent output provided:

Total Work Time : 466813

Time to Apply Cmds (ms) : 466813 -> distribution agent writer thread

Time to Retrieve Cmds (ms): 2050 ...

I don't know about SQL 2000 replication...I'm pretty sure it should work the same for merge replication but I might be wrong 🙂

Since you've setup your replication from a backup you'll have to manually create the SP on the subscriber after creating in on the publisher...

a) Create the SP on the publisher

b)...

From BOL:

Restrictions for TRUNCATE:

You cannot use TRUNCATE TABLE on tables that:

Are referenced by a FOREIGN KEY constraint. (You can truncate a table that has a foreign key that references...

Maybe this will fix it?

http://support.microsoft.com/kb/978518/en-us

Specify QA2..IV00101 instead of just IV00101 in the query and it should work fine (assuming that table IV00101 exists in the QA2 DB - otherwise specify the appropriate DB name)

osql...

If you need -ve integers also try something like this:

DECLARE @T TABLE(Val varchar(30));

INSERT @T(Val)

SELECT '100'

UNION ALL

SELECT '10.5'

UNION ALL

SELECT 'AAA'

UNION ALL

SELECT 'BBB'

UNION ALL

SELECT '-100'

UNION ALL

SELECT '-A'

UNION ALL

SELECT '100-'

UNION ALL

SELECT '55'

SELECT...

Gail and Jon are right - checked on my DB and if I set the compat level to 80 I get the same error...it's not an issue with DB_ID() -...

To elaborate on what Chris mentioned - you can try to see if you're not getting data by executing your query in parts...

For e.g.: first execute this and see if...

From http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx

Compatibility level setting of 60 or 65:

Columns prefixed with table aliases are accepted in the SET clause of an UPDATE statement.

Compatibility level setting of 70 or higher:

Table aliases are...

To check if you have enabled MaxCmdsInTran run the following query on the distribution server:

-- check if the ss.command column for the step_name "Run agent." has

-- a "-MaxCmdsInTran" in...