From time to time the linked servers we have set up cannot be accessed.
When
I click on the tables node under the linked server within enterprise
manager
the session hangs and no error message is displayed. When querying the
data
via an openquery no error is thrown, the query simply runs until manually
aborted.
I've created a linked server OK but immediately cannot open it. The only
way
around this problem we have is a reboot of the server. Does anyone know
how
to resolve this problem and also what would cause this.
Re: ContextSwitchDeadlock ... Have you tried to access the two data sources with a Linked Server approach ... For each record read via the data reader,... probable cause is a process is consuming too much memory....error message and continue with the process and it completes successfully, ... (microsoft.public.dotnet.framework.adonet)
RE: Linked server 7302 error ... Under the linked server security tab, nothing is entered except the last ... I still have a problem with my linked server and I still need some support.... > This issue looks strange because the error message... (microsoft.public.sqlserver.connect)
Write trigger to update linked server ... I write a trigger on a table and update another table in a ...linked server.... There is an error message....Heterogeneous queries require the ANSI_NULLS and ... (microsoft.public.sqlserver.programming)
Re: delete and update operation on linked server ... Whether you can delete or update depends on the provider.... and you may need a primary key on the table. ... tried and gotten an error message, post what you've tried and the exact ... >i am able to select rows from linked server but how can i update or delete rows which r thre in linked server suppose say. ... (microsoft.public.sqlserver.programming)
Re: Error with Linked Servers ... is it large set data you want to return? ... But the problem isn't so much in the query it's the fact that when you ... select the linked server the system hangs with no error message and the ... the session hangs and no error message is displayed. ... (microsoft.public.sqlserver.security)
