I wonder how many people will get it correct simply because the first two answers refer to it as a database login instead of a database user.

And I thank you for that!! I've worked as both a developer (VB, ASP, C#) and a DBA, and I prefer to be a DBA. So thank you for being my yin...

I don't think there's any of us here that would disagree with you there. But on the other hand, if it was all simple, anyone would be able to do...

Just be careful. There are certain circumstances where Set RowCount is ignored. Also, the RowCount will stay set within your procedure until the procedure either ends or you turnit off...

I think it was a great article for beginners. I also think the EM is a great tool for beginners to start with and Query Analyzer should be tought as...

I don't personally like using Select Into because if one of your columns has no data in it (all nulls) you will get an error stating that it can not...

An oldie, but goodie generic SQL joke:

Select * From Users Where Clue > 0

-------------------------------

(0 row(s) affected)

Use a global temporary stored procedure instead. To do this, you would need to prepend the name with two # signs instead of 1.

I knew what he meant to ask, but that's not what he asked. He should have asked if RS would be able to use both recordsets from the procedure. It...

Actually, the correct answer is yes. You can use the stored procedure, but reporting services will only "see" the first result set.

Difference between using PatIndex and CharIndex, you mean? Good question. I have not done any such testing, but it might make for a good follow up article.

The article was pretty good, but it was kind of anti-climatic. I realize that there are probably lots of people that did not already know the things in the article,...

What a coincidence. I have an article coming out on this very subject soon. I think next week. Doing support on various dba support groups, I encounter a lot of...

Good article. I look forward to testing out the code in the article and above. I know a time will come when I will have to do this. My general...

Me too!! Except mine is a cheapo Qualcomm from 2000 with Sprint PCS.

I'm going to get a new one soon too. And a hovercraft, yeah that's the ticket.