That's a pretty good list. I might scan with SMS or Ops Center if you have them to see what's down.

You might build a list of SQL Servers that need...

Just saw this. Very nice and creative. Had me smiling this am.

😀

That is a good point, and I do believe that shortly you won't be able to buy SS2K8 from MS. I bet resellers will still have it for awhile, but...

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