Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linkserver error
Message
From
22/08/2008 05:05:51
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
 
To
21/08/2008 09:28:07
Issam Mansour
Jordan Business Machines
Amman, Jordan
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01340735
Message ID:
01341047
Views:
25
Are you sure you are parsing it and not trying to execute it?

>Hi,
>
>I have the following statement on my SP giving a error when going a Parsing:-
>
>IF EXISTS (SELECT * FROM TEMPDB.DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'TEMPDB.DBO.#T_ITEM') )
>begin
> select *
> into #T_ITEM
> from
> OpenQuery( IRBID, 'SELECT * FROM ITEM ' )
>end
>
>the link server is not always available, the error i have is the following:-
>
>
>Msg 7202, Level 11, State 2, Procedure MOHD, Line 54
>Could not find server 'IRBID' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
>
>Best regards
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform