JOINing a derived table in place of the IN clause should do the trick.  Try this (and keep in mind I haven't tested it):

SELECT NULL CompanyName, NULL OrderDate

UNION ALL

SELECT...

It would be great if you knew for sure that it was a good or bad backup; however, all backups would fall into your #3 category.  One never truely knows...

You can try a RESTORE VERIFYONLY on the file, but I would suggest restoring the full and incrementals on a test server as this would be the best way to...

I like Sergiy's solution.   Just to add in another option for you, you could use an UPDLOCK hint on your first SELECT from the MyControlTable. 

Exactly which performance reasons are you concerned about that would keep you from using SELECT COUNT(*)???

I'm not sure what is going on with your breakpoints as they work fine for me here including the step in/out functionality. The problem with your stored proceudre not updating the...

What is the hostname and applicationname values for this entry in Profiler?  Both ALZDBA and mkeast are correct.  Someone is running this stored procedure and then using the statement 'select...

There really isn't any sort of precedence for T-SQL commands.  The precedence is done in the locking.  Your 'DROP TABLE' command is being blocked by the locks that the ROLLBACK...

Put your UDF logic into a stored procedure and only allow inserts to happen through calls to that SP or use an INSTEAD OF INSERT trigger on the table.

Check out the zip functionality in this link.  It has worked great for me.

http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp

Oops, sorry.....

I guess that we all get to run our post count up in this thread

Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

Just so you all know, there are definately more than 5 that have been reading this since the beginning.