Yes, I think you understand what needs to be done. Just one clarification:

SETSPN -A MSSQLSvc/myserver1 ServiceAccount

SETSPN -A MSSQLSvc/myserver2 ServiceAccount

SETSPN -A MSSQLSvc/myserver3 ServiceAccount

I forgot to add in the service account...

Are you using the FQDN in all connection strings? I know - stupid question, but have to ask it anyways.

To get Kerberos to work, you need to specify one of the SPN entries that was created.

If you just leave it to SQL Server to create it using...

Well, I gotta say my all time favorite wasn't a movie computer - rather it's a TV computer. KITT (Knight Industries Two Thousand). Who wouldn't want a car...

Sorry, but what the @%$#%@ does that mean?

Did you enter your request in Connect, and the SQL Server team turned it down?

You couldn't enter anything at Connect?

You can't connect to...

Have you recently changed the service account that is running SQL Server? For example, did you change it from LocalSystem to your domain account?

When SQL Server is running as...

Looks like you are connecting to two separate instances of SQL Server. Verify that both instances are at the same patch level.

That would be the only concern I would have - but, if all you had to do was load up the VM and 'migrate' it to the new platform that...

Lynn Pettis (12/18/2008)

---

Windows Server 2000 may not run on future physical hardware, but you should be able, if needed, be able to install Windows Server 2000 on a virtual server.

In...

So, once again I will ask the question. Given:

SELECT REPLACE('abcdefghijklmno', 'mno', 'abc');

What is the expected datatype of the output? VARCHAR - as defined in BOL.

What is the expected...

We first noticed the issue on a Sunday morning, when we found that our nightly maintenance from Friday night was still running.

So, yeah - it ran for a long time...

Very good - glad I could help. To convert the nulls to an empty string ('') - lookup the COALESCE and/or ISNULL functions in Books Online.

Before inserting the record, SQL Server needs to know whether or not the rows being inserted already exists. This would be defined by either a primary key contstraint -...

What do you want to happen with 'ufi_class' and 'ufi_status'. Those columns cannot be in the PIVOT because they are not being pivoted.

This is one of the problems we...

I understand where you are seeing this as a problem. What I was trying to show you is that this is not a problem, but instead your interpretation of...