How to execute a function via a linked server in the sql server 2000

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

How to execute a function via a linked server in the sql server 2000

-- Anonymous, October 25, 2004

Answers

Lismar,

Use OPENQUERY or use four-part naming.

Use OPENQUERY like this:

OPENQUERY (linked_server , 'query')

The four parts in four-part naming are linked-server-name, catalog, schema, and table.

Hope this helps,

Eric

-- Anonymous, October 28, 2004


Moderation questions? read the FAQ