Matt Miller (3/26/2008)

---

Not blasting the OP by any means... but sometimes a "different approach" means getting someone that knows how to put the...

Dunno about that, but there sure is in a BCP import. But, I think the DTS route would be better because if you're using text qualifiers in the file,...

Totally awesome find... but despite the DROPS I've done on tables and the like, there's nothing in the log. There is something, however, for someone dropping a database.... gives...

Ummmm.... you don't really need a CLR or external RegEx to do something so simple as to remove leading zeros. For example...

DECLARE @Sku NVARCHAR(500)

SET @Sku...

Even if you are - shouldn't you be keeping the audit trail of the updates to said stored procedure? You know, as in Source control? I kind of...

SMO would just slow you down and I don't think you need real dynamic SQL.

Why can't you just populate a table with the Old/New values and do a simple joined...

Sure, I get the same on the small test... times for the outer join vary between 16 ms and 67 ms with the norm being 47 ms... but look at...

How do you know that, Matt? Shoot, that's...

Matt Miller (3/26/2008)

---

Personally, I'd apply a Dr. Kevorkian to this app (meaning - take it out back and shoot it), and start over. There has GOT to be a...

Wasn't your fault... the "other" person started it that way.

One way to find the bad row is to import it into a two column table (1 for a row num, the other for the data). You know how...

If nothing has changed on the system, then keep looking in the source file... the problem is there and you've just not seen it yet. My favorite error is...

If it's for "point in time", then I'm pretty sure you need FUll Recovery and differential backups multiple times per day. Do 1 full backup a week... differential backups...

Heh... don't tease us, now. Would you...

I agree with Michael Earl... I've done this many, many times (cofiguration table that looks like a name/value or "EAV" table). I've found that it's very handy. When...