I have to agree with Vladan on this one.

The approach pointed out in the article is rather cumbersome, even for a one time thing.

Whenever one needs to compare data between...

I like writing and sharing my ideas with others because I believe that the higher level of general knowledge available then the easier it is for people to concentrate on...

This is awesome, I have always wondered how to embed reporting services in my applications. I will have to give this a try.

Just out of curiosity, do you know...

I have to agree with most of the comments here about the system being rather difficult to start using.

I have seen several ticketing systems which do AJAX searches while you...

I would say for the most part I have always been so low in the organisation that I am very grateful for any "points" I get toward buying things like...

I personally agree with you. Anything that is used to convict someone should, within reason, be available for public scrutiny. This might mean that some people will figure...

Sorry, the chopping term came from a keyword in another language.

I was trying to get the value to "truncate". However that project is long past for me so the...

I have seen a couple people mention that tables without children or certain logging tables may not need PKs.

I actually have a case of this. My table simply contains...

This looks like a really cool tool.

What would be really great is if the Data and Database comparison tools supported comparing multiple servers and pushing one servers differences out to...

Well fortunately I didn't have to pull the thanksgiving holiday duty this year, however I still enjoy reading the newsletter even when I am not on the job.

What I most...

I know this thread is going on 2 years old, however using it and other sources I have managed to cobble together a pretty decent solution for SQL 2000.

My problem...

I am also a fan of this idea. I do have one suggestion to add. I have noticed quite a few minor annoyances with SQL Prompt. If...

I agree Doug, I have used them for that purpose as well.

Nice tip about having to close the record set before accessing output parameters, I didn't know that.

Sideout72 (10/26/2007)

---

Jereme Guenther (10/25/2007)

---

So what is the advantage of OUTPUT parameters over a standard result set? From my experience they are much more of a pain to deal with...

"Output parameters make it easy to pass info between stored procedures."

That sounds like what I missed, I didn't realize they could be used between sprocs. That is really good...