Something weird is happening with hidden characters in the site's text box control. I copy-pasted the script and had to delete a bunch of white space to get it...

Thanks, that document explains a lot. I'm really suprised MSFT didn't make this easier, what with all the preaching about not using Sql logins and always going with windows...

Ok, I have come to the conclusion that it is not possible to link two Sql Server 2005 servers using windows authentication. I had to resort to creating a...

I'm logged in as the domain administrator.

Sql logins are disabled. I would rather not have to enable the sa account if I can avoid it.

The latest thing I have tried, which is at least giving me different error messages, is this:

EXEC sp_addlinkedserver

@server='statler',

@srvproduct='',

@provider='SQLNCLI',

@datasrc='np:statler',

@provstr='Integrated Security=SSPI'

-- Then I try this:

select...

There's no question that it was arithabort. I took each set option and ran it alone with the query after disconnecting and reconnecting.

Wouldn't I see that the plan was different when I was running it? I tried a few times and looked at the plan (with "Include Actual Execution Plan" checked)...

It was "set arithabort off". I haven't figured out why yet. That's the last thing I would have considered.

I just assumed that the defaults sent in by .NET...

Wow. That was it. Now the question is, why?

I pasted these into enterprise manager and the query took forever.

-- network protocol: TCP/IP

set quoted_identifier on

set arithabort off

set numeric_roundabort off

set...

I'm not sure how this formatting will work out, but here are the 2 queries, first the EM, then the web app. TextData is identical for both.

nameApplicationNameCPUReadsWritesDurationClientProcessIDSPIDStartTimeEndTime

SQL:BatchStartingMicrosoft SQL Server...