I've been wondering about this myself.

johnzabroski (5/10/2010)

---

Lynn,

I'll agree that Paul's OPENROWSET idea in conjunction with the "don't blit, just load" trick you mentioned at the beginning of this thread can form a good solution. ...

I actually think it comes down to marketing. Perhaps, as DBA's, we need to start talking about the Exceptional DBA of the Year award to everyone and anyone that...

Just can't do it. It's just too self-serving in my opinion to nominate myself. I'll admit, no one here at work knows about the Exceptional DBA competition, and...

Personally, I think it means more if someone else makes the nomination. It is sort of like nominating yourself for MVP, self-serving. I set a pretty high bar...

Yes, it is humorous, but it isn't even related to IT. 😉

My question is why are they debugging in production? If there is a problem, they should have a test environment in which to test and debug issues so they...

johnzabroski (5/10/2010)

---

Paul White NZ,

Your solution doesn't work on edge cases where data elements themselves may contain pipes.

As for using CLR, we use CLR heavily here in many exotic ways, especially...

I fully agree!

Thank you for the feedback. Glad the code is working for you.

kjkeyan (5/10/2010)

---

Hi i have requirement where i need to check the a business DB when the

parameter is getdate() ELSE ArchiveDB but its not checking the businessDB

when i pass...

The lesson here was not requirements, but what the OP has done to solve the problem presented. I asked this as this post is similar, yet different, from another...

mahesh.vsp (5/8/2010)

---

Hi Lynn,

Can i know the reason behind that? As per my knowledge a higher edition is not compatible with lower compatible edition. Example , we cannot restore a Enterprise...

Jan Van der Eecken (5/8/2010)

---

C'mon Lynn, you can't expect the OP to give you both a business plan...

Yes, you can.