Viewing 15 posts - 1 through 15 (of 17 total)
Did you receive any ideas on this issue?
September 5, 2012 at 4:58 pm
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...
May 30, 2012 at 10:10 am
Where was this registry setting located? I am having a similiar issue on some of my dev servers.
February 28, 2012 at 1:36 pm
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...
February 11, 2011 at 12:46 pm
Based on the article by Paul Randall, it does.
August 6, 2008 at 9:51 am
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...
August 6, 2008 at 9:25 am
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.
August 6, 2008 at 8:59 am
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...
August 5, 2008 at 3:38 pm
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. ...
June 18, 2008 at 12:43 pm
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.
June 18, 2008 at 10:52 am
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...
June 18, 2008 at 9:17 am
Oh, what is the real error that you are seeing?
June 17, 2008 at 11:24 am
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...
June 17, 2008 at 11:22 am
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...
June 17, 2008 at 11:18 am
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...
May 20, 2008 at 4:14 pm