How do you send the alert?

Sql Monitor would have this info (14 free trial).

Or this query :

SELECT * FROM sys.dm_exec_requests WHERE open_transaction_count > 0 ORDER BY start_time DESC

http://msdn.microsoft.com/en-us/library/bb395166(v=sql.90).aspx

Search for median. It's about a 3rd of the way in.

Go see the network admin. He'll know where to find this info.

You say you don't know what objects you can drop. I'm saying it's usually...

Oddly enough, only after I had posted 2 replies on the other thread ;-)!

Usually it's none of them.

Of then in will do the trick.

L8rs.

Roy Ernest (9/12/2011)

---

Ninja's_RGR'us (9/12/2011)

---

Roy Ernest (9/12/2011)

---

I am not sure why any one should even bother talking about that guy... Ignore him and help the OP is the best way to...

I've already answered this.

Please don't cross post, it just wastes everyone's time and fragments replies.

All replies over here please : http://www.sqlservercentral.com/Forums/Topic1173535-146-1.aspx

HTH, is strControlNbr nullable? If so you might be better off with a self join.

Does it work in SSMS?

Because if it works there you'll be able to populate the dataset and see the results. That I'm 100% sure.

Might be permissions issues if you...

My bad, I forgot to say Control panel after start. 😀

Roy Ernest (9/12/2011)

---

I am not sure why any one should even bother talking about that guy... Ignore him and help the OP is the best way to solve it I...

goofy is a nice way to put it!

Select intBonusID From tblBonus Where strControlNbr IN (Select strControlNbr From tblBonus Where intBonusID = @ID)

That makes no sense. What are you trying to do?