Syntax for query to another SQL-Server-Instance

Florian,

You need to include the LinkedServer name, shown as SQLSERVER1 below:

SELECT FirstName, LastName, EmailAddress
FROM SQLSERVER1.AdventureWorks.Person.Contact
WHERE EmailPromotion = 5

To execute a stored procedure on a remote server, the BOL has this example:

DECLARE @retstat int;
EXECUTE @retstat = SQLSERVER1.AdventureWorks.dbo.uspGetEmployeeManagers
@EmployeeID = 6;


RLF

"Florian L." wrote in message

>I have to mention that the SQL-Instance is on another Server (linked
>server).
 >> Stay informed about: Syntax for query to another SQL-Server-Instance 

Thanks for the info!

Regards
Florian


"Russell Fields" wrote:

> Florian,
>
> You need to include the LinkedServer name, shown as SQLSERVER1 below:
>
> SELECT FirstName, LastName, EmailAddress
> FROM SQLSERVER1.AdventureWorks.Person.Contact
> WHERE EmailPromotion = 5
>
> To execute a stored procedure on a remote server, the BOL has this example:
>
> DECLARE @retstat int;
> EXECUTE @retstat = SQLSERVER1.AdventureWorks.dbo.uspGetEmployeeManagers
> @EmployeeID = 6;
>
>
> RLF
>
> "Florian L." wrote in message
>
> >I have to mention that the SQL-Instance is on another Server (linked
> >server).
>
>
>
 >> Stay informed about: Syntax for query to another SQL-Server-Instance