Great article!  I emailed Jason a suggestion for the delay, to maybe use the ModifiedDate and LastRunTime fields in the Subscriptions table to test if LastRun is greater than Modified,...

The upsert functionality is available, just not using that term.  Take a look at using Intersect and Except to make it happen.

http://209.34.241.68/mat_stephen/archive/2005/08/31/410022.aspx

Ditto

The award for worst question of the day goes to...

I have fond memories of my first program.  I was 11 and wrote a combination text adventure (Zorkesque) with occassional graphic adventure sections called The World of Scum.  It was in...

No offence, but this is more of an out of context opinion than a right and wrong question.  As soon as I saw the question, my first reaction was "not...

I don't dispute the answer, but this is a wierd one.  All documentation references I found all only talked about 1434, none even mentioned 445.  Not very good from a Microsoft...

I just want to send out a thank you to the SQL Server Central staff.  These QODs have been helping me learn some of the finer points of SQL 2005...

Same comment here.  1, 'A' would have been right based on the question as it was spelled out.

Never mind.  I found the problem.  Very obscure issue that I found in the logs.  I had a user defined function in the model database because we use it in...