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...

We have a bunch of articles (http://www.sqlservercentral.com/tags/Integration+Services+%28SSIS%29) on SSIS and we have a new series starting soon that goes through the basics. It will go out over the next few...

I'd put Streaminsight in the ugly since it's just in Data Center edition. I might also put the fact that Enterprise has some lower limits on hardware though they're not...

That's an important fact to remember. The backup includes changes up until the backup finishes, not starts.

and a step to the right?

I shall disrgard this question and award points to everyone as well as mark a future "THis is correct answer.

I still disagree with the restart. In that content, the "restart"...