Yes, that would do it - I realize that if I give the account rights to register the spn it will work - through kerberos.   My question is why is...

No it is not a pivot query -  straghtforward select query with a bunch of joins and outputting 1052 columns

Thanks

KR

Actually, the size of the file is pretty small, although the number of columns are large.    It is just a test file with limited number of rows.  So  I am...

Yes, it has worked when it was 664.  I just opened the file in ultraedit to make sure it looked fine.  I don't need to use excel since this data is...

That is what I was afraid of.

Thanks

KR

Bothe server A and B are on sql 2005 service pack1 -  That is why I am puzzled, one server moves to NTLM, the other just produces an error.

KR

I just heard back from out Network admin saying that spn was never manually registered on the servers.  So I am back to square one.  Why would server A work...

I agree with the above assumptions.  However,  here are a few interesting things:  I found that the account is used on two sql servers and one works fine with tcp-ip(server...

To check the sys.dm_exec_connections, I would first need to make a successful  remote connection which would have to be named pipes(NTLM).  Is the authentication when connecting locally always NTLM?, because...

I did go through all the articles mentioned above and then some, but somethings are not clear to me:

All the above seem to indicate that a missing or incorrect spn...

Thanks much for the start up query, and all the very helpful suggestions that I have gotten form all of you.

This is part of a bigger process, so when I...

Kenneth,

Sounds like a good approach!  I will certainly try this logic

Thanks much for your help

KR

I am sorry if I was not clear,  I am not concerned about the employer. 

What I am looking for is to be able to export, say top 15 employees...

Member number is the only connecting point -  If they have the same member number, they are family.

Thanks

KR

Here is a better explanation of my question:

Sample Data:

Columns: MemberNumber, FirstName, LastName, Address,RelCode

Data:

12345,John,Smith,123 Ave, 18 --- This is the employee record

12345,Sara,Smith,123 Ave, 01 --- This is the spouse record

12345, Paul,Smith,...