Thanks!

This works, although it sounds like a pain to have to create that no-op just to set the meta data.

Thanks, but same result as last time.

Oddly, if you add 'set nocount on' to the procedures, all but the procedures that deal with #temp tables work.

CREATE DATABASE TEST

GO

USE...

I think that last case statement is the best solution so far.

Thanks everyone for your help.

In the end, I am really interested in why the Optimizer thinks applying a...

You are missing the table name in the CTE clause.

You can place the where clause right after the table name like normal or you can do it in the...

Thanks Drew, that is exactly what I was hoping to learn.

I haven't used CTE's before, but they look very interesting.

Well that looks like an excellent start, and much simpler then the approach I was taking.

I guess I was just stuck on using datediff...

Much Appreciated.

I have done this before as well.

You want to modify the sp_MSdel_TableName stored procedure on the subscriber so it doesn't delete anything.

This can be rather annoying if...

I believe there is one sysobjects per data base.

If you run the following query you should receive three different ids but...

Anyone?