MarkusB (1/13/2009)

---

I just did some testing myself and even though I can't find anything in the official documentation it seems like the function get_sid() has been removed from SQL 2005...

Okay...hmm...I tried this workaround. I created a stored proc called my_sp_validatelogins with nothing really in...

Most of our servers are 2005, but some are 2000. I'm only using 2008 to run the query across multiple servers simultaneously (eventually), but the issue is failing on...

Here's a real life example for a database....

Exactly...If you don't mind paying the extra coin, there are some powerful 10-12 inch laptops out there. Not...

Dennis Stephani (1/2/2009)

---

Also try the following code. We had some issues where our tape backup system missed archiving some DB backup files so I scheduled the following code to check...

Hmmm...I get it. I guess the first rule...

Thanks Richard, it did shed quite a bit of light. I do have one followup on it though. If the...

Steve Jones - Editor (12/29/2008)

---

It looks like most people like separation by versions, and perhaps that still makes sense. My guess is that most people won't list their version, and...

dford (12/24/2008)

---

Lot of good responses here. I have to say, I don't like seeing lopsided articles about getting rid of cursors. They exist still partially because there are...

jacroberts (12/24/2008)

---

Shane Redding (12/24/2008)

---

Does anyone know where all this negativity came from about cursors? All I've read about this year are articles saying get away from cursors, "Very Bad" for...

Sigh...

The while loop I used was only a proof of concept, and was designed to show people the mechanics of breaking out of a cursor mindset. They are both...

Because our company has two seperate QA and Dev departments staffed by competent people, any outside contractors, either hired for a week or two or for months on end, have...

Here's a scenario where I had to use both procedural and set-based solutions (although I did avoid cursors). I get a request from an analyst every week or two...

I guess I object to cursors because of their awkward looking syntax more than anything, although their performance compared side by side with equivalent rewritten set-based or even conventional procedural...