Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Linkserver error
Message
De
22/08/2008 05:05:51
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
 
 
À
21/08/2008 09:28:07
Issam Mansour
Jordan Business Machines
Amman, Jordanie
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01340735
Message ID:
01341047
Vues:
26
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform