Thanks, but already tried that.

Ok thanks!

How do I mark this as closed?

Ok - so it sounds like I only need to register the FQDN and not the dns name with SETSPN.

Wow! Thank you Jacob!  You are awesome.  I don't understand why you had to use MAX considering there is only one value for that name but you don't want to...

Here you go...

A 1000 Thanks. I'm beat, will give this a shot tomorrow.

I agree. I know what the problem is, that it doesn't know where it left off. I thought there was a way to use the MAX or MIN...

Thank you!

I will give that a shot, or my SysAdmin will.

Yes we upgrade Dev/Staging first.

More information I was able to get.

The two nodes a giant physicals

Currently four 10gb ports dedicated to iscsi - two on each iscsi networks

Two one gb ports bound...

I'll answer the questions I know. I'll have to ask systems for the other information.

There are only two nodes in the cluster. I believe the quorum is a...

Let me add that the MDF and LDF files are on the same drive. I told the people who created the database to not do this as it's...

The account being a SysAdmin doesn't cover all those permissions?

I was able to get it to work using the @body tag instead of the @query. I created it in...

Thanks for the response. MessageText is nvarchar(2048) and dbid is int so DB_NAME(dbid) returns the name of the database. The statement runs fine on it's own. Even...