I didn't see your response as nasty. Came across fine to me. I have added a note to the top and bottom of the article to check the discussion.

Actually I think this is the way to do. So many people have complained about features in SPs, myself included. I prefer SPs to be just fixes.

Adding those new features,...

http://www.sqlservercentral.com/articles/Video/63805/

Tom,

I think a lot of companies are looking at things this way. Some may even skip SQL 2008 and R2 from 2005 to jump to 2011 or 2012 since...

It's not in NA either. Our current lead isn't a SQL person, and also has some development area MVPs. I've had, I believe 4 leads, only one has been a...

As long as the trigger is firing, any locks required by the update statement and the trigger will be held. The way you have coded this, you could be holding...

I'll chime in as well. DO NOT USE Agents. Some work, some don't, but I've had issues with a few and it's not worth it. The convenience of their doing...

I think Lowell's hit it on the head. The issue is that while the trigger runs, the transaction from your update continues, and all locks placed are held. Using a...

I'm not 100% how to do this in SSRS, but if you have things working in SSMS, you could create a view with your unions and then query that from...

It's hard to tell from that what rows you're removing. What is the criteria on which you want to build results? For each ID, I need all the ORDERIDs, or...

Is there a question or issue here? Please do not just post code in the forums and expect people to understand it. I am removing the code for now. If...

This help? http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html

I've debated this with people a few times and I tend to agree with Gail. Publishing a set of criteria (xx forum posts, yy blogs, zzz speaking engagements, etc) would...

Andy Leonard (2/7/2010)

---

Interesting thoughts Tony!

Recently, MVP nominations were opened to the public. Anyone can now nominate someone for MVP at the public MVP site - you can even nominate yourself....

Remote connections are disabled by default, but they can easily be enabled.

What connection string are you using? It appears that you haven't necessarily specified an instance from the error, and...