Click here to Skip to main content
15,884,041 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
hello Friends...

i m using sql server 2008 on windows server 2008 r2. it contains a database named 'muri'. and i have created a linked server to proficy historian using iHistorian OLE DB Provider. i executed some query for linked server. It was working Fine till morning.
when i run simple following query.
SQL
select * from openquery(ihist,'select * from ihtags')



it went executing until i close the sql server.It takes long time but don't complete execution. first i thought sql server went slow down. but when i run simple query to my muri database as follows.
SQL
select * from employee


it is working perfect. after that i tried to delete existing linked server, this also showed progress as executing but don't complete execution and deletion.
then i tried to create new linked server with different name, same thing happened with this also.
it can't delete existing linked server,can't create new linked server and can't execute openquery as follows
SQL
select * from openquery(ihist,'select * from ihtags')


plz help.
thank you
Posted

1 solution

Querying a linked server will be slower than local data and is directly proportional to your network availability and throughput.

If you are only querying the data then try creating a local copy of the data and periodically sync it with the remote linked server.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900