Here's a way that doesn't use a calendar table.  It counts the # of weekdays though...

DECLARE @dateStart DATETIME

DECLARE @dateEnd DATETIME

SET @dateStart =...

I had to leave outlook OPEN on my SQL Server in order to be able to read new email messages.  See if that helps you.

I'm not sure how to do that directly but what if you check @@error immediately after?