Why not handle that in the application layer? I would suggest that would be the normal place to do so.

As for writing a script, we're not here to...

That's got to be a pretty old tutorial if it's referring to Reporting Services 2005; that's well out of support now. The deployment model has change a little bit since...

Have you had a look at DDL triggers at all? I assume by "save" you mean if someone used the CREATE syntax? What about if the object was updated? Would...

Firstly, code like the below is open to injection:
NewString = "INSERT INTO LOCAL_Item VALUES (" & "'"& Code & "', '" & fBaseBOMGID & "', '"& Description...

I'm surprised that any of those KB's caused you to lose connection to the SQL Server. Did the same issue happen when deployed these KB's onto your test environment (I...

I said a small sample please,with expected results, and (like mentioned above), provide a copy of what you've attempted already.

Good luck with this, but I'm out.

Considering that your excel file was 564kb, and your rar is 72kb, I'm not seeing how that would ever contain 10M rows of data. However, we don't need anywhere near...

It's an attachment again? Put the code on your post, please.

As for your error, the reason is because you have values greater than 9999.9. what are you expecting to happen to those values?