Ian,

The SQL Logs show each time that SQL started - you could parse that. And assuming a normal shutdown, that also is recorded, so you could parse the logs for...

tom 29037 (8/2/2010)

---

I have to admit that I don't quite get his explaination, but I also haven't got a chance to play with that code yet. I'll be using...

ColdCoffee (8/2/2010)

---

Wayne, awesome job in that explanation , mate! Thanks.. Hope the OP now and the other poster got what the code exactly does.

Also i remember a thread where RBarryYoung...

So, you just need to get @@datefirst, and adjust accordingly. Something like:

declare @DateFirst int

set @DateFirst = @@datefirst

SET DATEFIRST 1

--...

diegocroitoru (8/2/2010)

---

SSC Eights,

Great response.

Do you mind elaborating more on the:

FOR XML PATH(''),TYPE

).value('.','VARCHAR(MAX)') , 1,1,SPACE(0)) AS Concat_Values

string of your...

Sigh. Only until she gets used to it. Then I'll be looking for...

Change the function to:

ALTER FUNCTION [dbo].[zfn_get_last_inv_Receipt]

(

@item_id as int,

@whs_code as varchar(8)

)

RETURNS smalldatetime

AS

BEGIN

DECLARE @last_receipt_date smalldatetime

then change how you're calling it by taking out the ", 0"

Edit: What you are doing is passing...

GilaMonster (8/2/2010)

---

High cost of living.

My rate is about 1/5 of Wayne's. My income (in...

First, I created this code a little time ago to shred apart the xml of a deadlock graph.

declare @deadlock xml

set @deadlock = 'put deadlock graph here'

select

[PagelockObject] =...

I just had to submit my rates for this. 😀

Edit: Now, if I can just...

$500/hr. 10hr/month minimum. 6month minimum. Paid in advance. Interested?

Steve - it appears that we've found the issue.

I was going through our cluster setup document, ensuring that everything was set up properly.

When I got to the end where we...

Okay, back to this issue.

When the cluster is running off of Node A (the normally active node), scheduled jobs run just fine.

When the cluster is running off of Node B...

Thanks Tom, I'm glad that you liked it.

I have a version of this that will read the deadlock from a...