First I want to point you to this article[/url] as I think it will help you understand what Todd and Sean are saying. SQL Server triggers work differently than...

You can do this by running a server-side trace as well. You can trace the RPC:Completed & SP:Completed events. The issue is that you need to run it...

You can use a filter on the table, but as Daniel said, you are better of creating a group.

Can you post the code?

How do you know the whole database is locked? What is the output of sys.dm_tran_locks? What are the symptoms?

Gus' post is very good. I used to be a SELECT guy, but because SELECT does not throw an error when more than 1 value is returned I have...

Are you connecting from the local pc or from another computer?

What application(s) are you using to try to connect?

Y'all are welcome. I'm glad it made sense.

Grant Fritchey (3/23/2011)

---

SQLkiwi (3/23/2011)

---

Grant Fritchey (3/23/2011)

---

Since we're paying the facility per person, we have to try to keep our attendance at 325 or we'll owe more money. It's a dance...

David Benoit (3/22/2011)

---

Yeah - I'm about 6 hours away (not 24) driving but may still try to get on that list and start to plan for the trip.

Thanks for...

SQLkiwi (3/22/2011)

---

David Benoit (3/21/2011)

---

SQLkiwi (3/21/2011)

---

About 40 minutes short of...

Congrats. I need to get that cert. The new features...

Yes since I'm in process and you have my email....

CirquedeSQLeil (3/8/2011)

---

jcrawf02 (3/7/2011)

---

Every once in a while, I am reminded by circumstances to thank everyone here and out there anywhere who takes the time to help others out in their...

Congrats! Someday I'll catch up on my reading and get to it I'm sure. Of course at...

GSquared (2/28/2011)

---

Kiara (2/28/2011)

---

jcrawf02 (2/28/2011)

---

Stefan Krzywicki (2/28/2011)

---

jcrawf02 (2/28/2011)

---

I'm just growing tired of having to explain Microsoft's commercials to my wife. Some idiot on the screen says "To the Cloud..." and I...