Yes,
I'm just encountering problems with two SQL 2000 linked servers.
Queries which used to take max. 1 minute now are running for hours.
No major changes in the SQL code, database configurations...
Even I'm using native SQL authentication, I still guess there is a Windows
network/ PDC problem causing issues to the underlying "Security Account
Delegation".

I guess you need a reliable Windows infrastructure, otherwise you'll get in
serious trouble.

-----Original Message-----
From: Gardner Richard
[mailto:mssqldba-ezmlmshield-x84028341.[Email address protected]
Sent: Wednesday, August 25, 2004 1:20 PM
To: LazyDBA Discussion
Subject: RE: Linkes Servers

Well there's a big topic - what dbs are you linking? MS to MS?

Richard Gardner
IT Manager

Tann UK Ltd


-----Original Message-----
From: Ferguson Keena
[mailto:mssqldba-ezmlmshield-x70766404.[Email address protected]
Sent: 25 August 2004 18:12
To: LazyDBA Discussion
Subject: Linkes Servers


Does anyone know of or have any negative issues with linked servers ...

Keena Ferguson

Sr. Database Administrator
Comdata Corporation
[Email address protected]
615-371-3483
www.comdata.com




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page