If it matters which server has its tables published for replication then set it up that way first if possible. 

I just looked at a few tables from the publisher...

I don't think it matters if you do it with the two if's or use the case function in an UPDATE.  It will matter when @Old_Psz = '555' AND @New_Psz...

I have tried to use parameters in DTS packages in places other than the WHERE clause and got similar results.  I don't think DTS supports using parameters anywhere in the...

I am not an expert with clustered servers, but if it is possible to rename a clustered server then I recommend moving all the backups to the new server, restoring...

dphilip:  You get no error when inserting a row into a table with this trigger.  I have developed triggers for UPDATE, INSERT, AND DELETE that correctly handle each situation.

Jack Corbett: ...

You can thank me or curse me for the trigger.  I designed it for the Question of...

I am the writer of the question and yes I failed to proof and test this one enough before submitting it.  I plan to do better in the future.

Let me see if I can respond correctly to your posts.

NPeeters:  Forgive the trick question.  I will do my best to avoid them in the future.

alfy:  In this case it...

I would welcome a reduction in points given for posts, but my reasoning would be to make it easier for me to win the prize I want out of these...

I hope it is not too simple.  Does the lack of complaints mean I finally made a Question of the Day clear enough that no one can dispute the correct...

Nice solution noeld.  Before now I never saw that before.  Thanks!

you will have to use dynamic SQL for your SELECT statement or parse the string and save all the values in a temp table and then use the temp table...

I can help with the example you gave of dropping a non existant table.  For each table you try to drop use this code:

if exists (select * from dbo.sysobjects where...

Oh, I have no intent of being more specific when giving estimates for when a job will be complete. 

With the Questions of the Day everyone has come along different...

I just read that article.  Yes be sure you can accept the situations as explained in the article.  Where I used it was on an isolated table that was used...