Re: 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." <FlorianL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0452B5A2-C6C1-427B-93F5-4AA83DCEB878@xxxxxxxxxxxxxxxx
I have to mention that the SQL-Instance is on another Server (linked
server).


.

Relevant Pages

  • Re: OT: security
    ... this remote file will be included into ... the script and executed. ... Note that the remote server would have to ... Mechanisms such as the above allow attackers to execute any code they ...
    (comp.lang.php)
  • Re: copying data from one server to another
    ... EXEC sp_addlinkedserver 'RemoteServer', N'SQL Server' ... Based on security settings you may need to map remote server logins. ... Then you just run a normal query referencing the linked server table with 4 ... 'SET IDENTITY_INSERT ON' before execute insert ...
    (comp.databases.ms-sqlserver)
  • INSERT takes ages...
    ... On a remote server I execute the following ... Now I wish to put the resultset ... Hans Brouwer ...
    (microsoft.public.sqlserver.programming)
  • Re: Send File to Remote Server
    ... It really helps me if i have the code sample on sending the file to ... This file should be sent to the remote server. ... then execute it on the fly. ... You can gain more control, often at the expense of maintainability, by using ...
    (microsoft.public.vb.controls)
  • RE: Access to a remote SQL server through ISA server
    ... Make a network trace on both sides (SQL1) and (SQL2). ... Use osql.exe connect to the remote server and execute sp_tables. ...
    (microsoft.public.sqlserver.security)