This will sound a bit like sacrilege on my part... I agree that for some management tasks, they're probably ok... but those types of cursors aren't usually all "RBAR"... normally...

Thanks Matt. Learned something new today! 😉

Absolutely no hard feelings here, my friend! 🙂 Good heated debates like this either bring out the best in folks or the worst. You've easily been in the...

Matt,

Awesome. Can you post the test code? That sure sounds like a "keeper" to me.

Marios Philippopoulos (4/1/2008)

---

Jeff Moden (4/1/2008)

But, the real key here is that CLR's are not necessary for 99.9% of anything you do in a database. It can all be done...

srienstr (4/1/2008)

---

Ridiculously late addendum, but Cute-PDF is free and has worked wonderfully for me so far, at least with things that are properly formatted for printing, it chokes a bit...

Are you going to do that from a GUI where parameters are normally passed as CSV's?

Karl,

Would you be kind enough to post your cursor code? I'd like to take a peek at it becauase I think I've only written 2 in my life...

To add to what Matt just said... if the server logs in as a domain super-user that can see all the machines and at least some "shares", using a little...

rbarryyoung (4/1/2008)

---

Why not both? ...

Marios Philippopoulos (4/1/2008)

---

Both are necessary....

Marios Philippopoulos (4/1/2008)

---

Matt Miller (4/1/2008)

---

Which is an interesting thought. The problem is - I'm pretty sure you have to flag that CLR as "unsafe" in order for it to...

I agree... he must be busy on Simple-Talk. We should pay him a visit. 😀

Nicely done John... You saying you like Scenario 1 or something? 😉

You should see how fast things run in the NV tables when you've had the time to add the...

No, no... no humiliation......