I would be curious to know what reason in the world one might have not to stay current on SP's...

Jason, you...

I was quite impressed by the MI computers in the latest James Bond. That's how a dream computer should work.

But to me, the best computer scene in all the movie...

What really makes me smile when I receive a gift is to get something I like, but I would never have imagined the other person would have known it even...

dobberteen (7/15/2008)

---

Mike C (6/18/2008)

---

dobberteen (6/18/2008)

---

we've been getting hammered by the version of the attack that inserts the javascript mentioned above, thanks to a complete lack of input validation and total...

Hugo Kornelis (7/9/2008)

---

Thanks, David. You have my vote.

(BTW, did you remember...

Hugo Kornelis (7/9/2008)

---

Hi David,

You overloook the human trait that, when working on something complex, one often tends to overlook the basic. Just today, for instance, I noticed a suggestion on...

Hugo Kornelis (7/8/2008)

---

davidthegray (7/8/2008)

---

Hugo, yes sure, I'm well aware about the risks of SQL injection. I always validate the input coming from the public web site, and I'm used to...

My main gripe with dynamic SQL is not it's deprecated (is it? I wasn't even aware of that!), but that, unless you exercisse extreme care, you run the risk of...

Thanks for the answers to my question. Looks like in my db I have 23, among sp's and triggers, using cursors, all written several years ago, which makes about 1/10...

Does anybody have a ready made query to find out the list of all the stored procedures in a db having the word 'CURSOR' inside their SQL body text? 🙂

Ok, I think next QotD could be "how to write a query to increase the scores of those who (correctly) answered just 2 to today's QotD?"

dobberteen (6/18/2008)

---

we've been getting hammered by the version of the attack that inserts the javascript mentioned above, thanks to a complete lack of input validation and total reliance on the:

rs.Source...

I run a web server where the oldest pages date about 10 years of life, and are still in old .asp.

Unfortunately I knew the answer very well. I had a...

rbarryyoung,

The error I got was:

Messaggio 15151, livello 16, stato 1, riga 1

Impossibile trovare l'oggetto...