CODEWITHSUNDEEP
sql-serverssms
Advance Software
Advance Software

Reputation: 73

SQL Server linked server in Management Studio

I have a linked ODBC server (not SQL Server) defined in my SQL Server Management Studio.

The only way I can query it is by using the OPENQUERY command, and that's fine - but it doesn't allow visual query editing or any intellisense.

Is there a way of typing queries against linked servers that behave in the normal way, even an extension?

Upvotes: 1

Views: 788

Answers (2)

Alexander Bolgov
Alexander Bolgov

Reputation: 81

You use 3-dot syntax, like this,

<server>.<database>.<schema>.<table>

but it works properly only with linked servers to other instances of MSSQL.

Upvotes: 1

P.K.
P.K.

Reputation: 1772

Try format like this:

<server>.<database>.<schema>.<table>

example:

select foo.id 
    from databaseserver1.db1.dbo.table1 foo
        inner join databaseserver2.db1.dbo.table1 bar 
            on foo.name = bar.name

Upvotes: 2

Related Questions