Good article!   Great points, great screen shots and well written.  While most of the commentors suggest using other tools (which is fine), they don't tend to address the real issue... ...

I've been designing, writing, implementing and supporting complete accounting systems for 30 years.  When I first started using SQL, I experimented a bit with some of its capabilities.  I quickly...

Peter Schott (12/23/2015)

---

blog 24112 (12/23/2015)

---

chudman (12/23/2015)

---

Did you execute the script within the context of the database you want to analyze? If you run this script against the default database...

chudman (12/23/2015)

---

Did you execute the script within the context of the database you want to analyze? If you run this script against the default database when you open a...

Hey, Thanks! John. I really appreciate someone that actually reads peoples comments and replies. I've been designing complete applications and their databases for over 25 years, so I'm...

Nice story John. One I'm sure most of us that have been working in our field for longer than a few years can relate to.

I had a question, and...

GilaMonster, Just to make sure I'm understanding what you're saying... in the event of two users concurrently trying to add the same row, the way the SP is...

I'm checking the Readers "HasRows" property after running the stored procedure, and it's false. Would the two different result sets have different HasRows values?

I'll give it a try anyway....