Heh... Welcome back my ol' friend.

What the heck just happened with our profiles?  I just did windows updates, which actually logged me off of SQLServerCentral and when I logged back in and checked my profile,...

If you want any more advice on this one, send money. 😀

Agreed... That's why I have stated multiple times that this was for a single batch INSERT and that folks need to look at Paul Randal's article that I cited for...

Ok.  I wasn't believing my eyes and ran some code a couple of times.  Basically, the code build a decent size table with a Bigint column and a LOG column...

Personally, I never install SQL Server on the C:Drive.  I also never let the "Page File" live there and I also install all programs other than SQL Server on a...

I have no suggestions based on what you posted.  Everything seems correct but your check in msdb.dbo.sysmail_allitems seems to say they didn't actually go but there are no errors anywhere...

I'm going to have to defer to someone else on that question for details.  I stopped doing anything like that way back in 2003.  I do remember that there was...

I almost forgot.  One "trick" I do (that I didn't do here) is to add an "_stg" suffix to the column names in the staging table so that when I'm...

I used to use EXCEPT but usually don't anymore because an old friend showed me long ago just exactly how slow it can actually be and Andy Leonard confirmed that...

One great aid for me is built into SSMS itself.  Let's first make sure that you're setup for it.  The setup only needs to be done once.

Step 1: From the...

It's late, so I might be missing something here.  Are you...

yup  .... and...

It's a bloody shame that the "upgrades" to the forum software have rendered such links totally useless. 🙁

I assume you know which login dropped/created the procs.

and assuming you are a SYSADMIN what output do you get out of these

execute as login = 'loginname' SELECT * FROM...