Did you receive any ideas on this issue?

I spend time trying to convince myself. One example I came across was using powershell to gather sizing information without recreating linked servers. I had earlier used linked servers...

Where was this registry setting located? I am having a similiar issue on some of my dev servers.

Thanks:-)

Mark

I agree with most of the posters here. Make the back end as stable and boring(stable) as possible. Know that you have backups in place for the 'Oh...

Based on the article by Paul Randall, it does.

That is true. Now if you have auto statistics turned on and a query touches those columns it would update those statistics at that time. Does that sound...

I was doing some rebuild of indexes on one of my test systesm yesterday and yes it does update the stats associated with the index.

😉

It sounds like your server is running okay. Each connection is going to tie up some amount of memory, so more connections more memory tied up. Pooling would...

I'm not sure that I'm following myself.

It seems like you created a sql server authenticated account, and it could access the linked server and select data back from DB2. ...

Sounds like the real error may revolve around not having sql server access to the linked server itself and not the access back to DB2, maybe.

We use specific accounts on linked servers and windows authentication, does the sysadmin account on server A have access as an admistrator on the server that gives it access to...

Oh, what is the real error that you are seeing?

Is it possible that the password on the linked server is out of whack? Does not seem like dba should be able to use the linked server as is...

I think Alzdba is on the correct path. Have a DB2 dba double check the accounts involved for access to the DB2 data. I would start with niedtl...

I understand most of this discussion. I have a 64 bit, x64, and sql server 2005 64 bit standard. Is there anything that I need to do, options/configurations...