Let's just say that management came around to my way of thinking after losing a days work

Ok, so do you know about exception handling in .Net? Do you know how to get the text of the error message?

Just to hijack the thread a bit further

One thing I...

Hey Frank, do you have a function key setup for that reply yet? It's amazing how many times it gets posted and still no-one searches before posting.

I'm with you here. Isn't this one of the reasons why the idea of a staging environment was conceived?

BCP into staging tables that are sans indexes. Then insert/update/delete production tables...

From the Bible for all would be SQL Server DBA/Developer's aka Books Online,

CPU busy

Well that would explain it. I can't see any AddNew method in the code you've posted.

Maybe you need to give a bit...

At what point do you get the error?

Please do not cross post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=186423

Also, this has nothing to do with Notification Services so it shouldn't be posted here anyway

You'll need to specify the OUTPUT keyword on the EXEC PROC command. eg: EXEC PROC ?, ? OUTPUT

Also, have you specified the parameter as an output parameter in your stored...

Use a function the returns a table to split the values and use the variable in the from clause.

There are a couple of example scripts in the script library. If...

Personally, stay away from backup agents, once bitten twice shy.

Sorry I misread your original post.

Differential won't allow a point in time restore, but you perform differential backup sin conjunction with transaction log backups...

This the "soon to be" production box. No changes that I know of where made on the box. The network guys are starting to act a bit cagy though. The...

Yes but, because the differential backup contains portions of the database changed since the last full backup, wouldn't your differential backup become larger and larger as it tracks each change...