SQL Server Performance Forum – Threads Archive

linked server

I am getting an eror while executing the SP on the remote server as linked server. I can do a simple select statement no problem but execution of SP is chewing my brain off
any help is appreciated. I have SQL server 2005

what is the error you are getting —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Without error info it hard suggest anything…, please post error info as requested… what are the server options enable in Linked server configuation?
Is RPC enabled? if not enable and try again… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Make sure you are executing that query with valid linked server syntax, refer to BOoks online for more information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

sorry for late response. we had to reset the MSDTC as we have the server in the clustered environment. Now It is working.
thanks for all of your help

Thanks for the feed back but make sure you guys provide complete info about the sql server and the errors other wise it is hard for us to answer…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Very few will provide such information on the first hand [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />], you will get used to this anyway. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by MohammedU Thanks for the feed back but make sure you guys provide complete info about the sql server and the errors other wise it is hard for us to answer… MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy. <hr height="1" noshade id="quote"></blockquote id="quote">

Yes Sir [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Learning new things every day… MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>