100% on our entire server infrastructure including email and archiving platforms.

Ohhhh its a reference to canines?! Hmmm tenuous link that one.... :-S

Brilliant! Love it!

Hi Lowell,

Yes "MyLittleAdmin" probably WOUDL do the trick but the price is a little prohibitive at the moment :0( If I could get a copy of your web page...

Grant Fritchey (12/5/2012)

---

david.williams 50026 (12/5/2012)

---

No but i_att_type IS a column, how do I tell it to use that? I thought WHERE ID = i_att_type; was telling it WHERE to...

No but i_att_type IS a column, how do I tell it to use that? I thought WHERE ID = i_att_type; was telling it WHERE to update?

grrr I am using the following syntax:

BEGIN TRANSACTION

UPDATE dbo.attcat

SET Val = 50

WHERE ID = i_att_type;

--ROLLBACK TRANS

But keep getting:

Msg 207, Level 16, State 1, Line 2

Invalid column name 'ID'.

Ok fixed it by replacing TRANS with TRANSACTION :0)

Hi Grant, I get the followign errors when running this:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'TRANS'.

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near...

unfortunately the link redirects to a generic Microsoft site rather than a download 🙁

that's certainly worth a look at!

Cheers!

Sent this a little too soon, figured out how to put it into a SQL Agent Job and schedule it every 2 minutes to run. Now waiting to see...

Hi Again Chris,

Looking at what U have below that woudl be enough as I woudl ahve to RDp to the SQL box anyway to clear the block but how woudl...

Chris Harshman (12/4/2012)

---

david.williams 50026 (12/4/2012)

---

OK I have created a new Agent Job... and the 1st step calls the SQl Query "Blocked processes" which consist of:

SELECTCOUNT(*)

FROMsys.dm_exec_requests AS der

WHEREder.blocking_session_id >...

Chris Harshman (12/4/2012)

---

another method, which is the one I use in a couple of production OLTP type systems utilizes Service Broker. The advantage with this is you can set...