Hi,

The usual NT AUTHORITY\ANONYMOUS LOGON error. Don't get it when I do oledb. Very strange.

Thanks!

Thanks for the reply!

No SSPI setting on the linked server that I can tell.

Doesn't look like any of those are the issue.

Kerberos is set up and I've made sure that connections are being made via kerberos.

SPNs and delegation set up (but maybe not the way the SQL Server type needs?)

The values...

Thanks Crispin, Have one for me!

Thanks Crispin. Alas, it's an automated load and pausing the server might be a hit and miss thing and the user I have doing the loads has minimal priv's...

Thanks. I could probably add and remove the user role from the db_denydatareader role, but I was hoping for something slick like sp_denylogin/sp_grantlogin for standard database logins, but it...

Thanks. I lost 6GB of space to a table that has mostly varchar and int datatypes. I had just reindexed this table the week before so I'm still...

I forgot to mention that I'm on SQL 7.0 sp4 and the tables in question do not contain blob or text data.

Any help would be greatly appreciated.

Thanks