ouch, the custom delimiters finally soaked in; that' certainly adds tot eh complexity, since i'd normally BULK INSERT something custom delimtied...but you need the tables built on the fly,...

Lucas the plain set @provstr = 'Text' was what is working for me; the other one was one that i was testing, and not applicable here.

for the error you...

NJDave (7/1/2013)

---

Hello

An application that sits outside of our network will allow the user to store pdf files on the database.

The concern is that these pdf files could contain viruses.

The vendor...

Lucas the strategy depends on the details.

I'm not anti -SSIS, but if it can be done via TSQL, then it can be done a lot faster.

if the destination tables...

ok, if you cannot remove records due to your audit requirements, i think it comes down to query tuning;

can you grab some execution plans, and see if any of the...

your settings for CDC were probably set to keep data for 100 years or something,a nd now you are seeing some performance inpact;

I setup CDC on a few tables, but...

arbcoll (10/10/2012)

---

Back to the issue SSC Veteran reported on the second post of this topic, I had the same experience - lost my 2 day work after an autorestart during...

instead of returning a zero when there's an error, just throw a sqlexception, and that will return the full error message, so you can track it down completely.

if it's a...

yeah i strugged thru the broken DDL as well;

unfortunately, becuase you have no true relationship to the two tables, you have to make assumptions to get teh data to work...

I've got a CLR i created that does a proof of concept reading of mail from a POP3 server; i'm slapping together an article for SSC on it;

The problem ...

i believe you need to script out the jobs, and find and replace the old server name with the new server name; As I remember it, the jobs have the...

darthurfle (6/28/2013)

---

Hi Lowell,

I am not trying to make the solution harder. It is a real world situation.

The table in question is a SAP ECC Add-on "standard" table that establishes relationships...

you want to use raiseerror as a progress indicator from some dynamic SQL, is that it?

here's one example that would be appriate in a cursor loop, does this help?

--print error...

ok i still don't understand the issue i guess; I think you are over complicating things too much.

correct me if i am wrong, but you need to delete ALL data...

or grab them all in one data set, duh, i should have posted this first!

SELECT object_schema_name(object_id),

object_name(object_id),

DEFINITION

FROM sys.sql_modules

ORDER BY object_name(object_id)