Top "Linked-server" questions

The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.

SQL 2005 - Linked Server to Oracle Queries Extremely Slow

On my SQL 2005 server, I have a linked server connecting to Oracle via the OraOLEDB.Oracle provider. If I run …

Read More
sql-server-2005 tsql linked-server
SQL Server 2008: What is lazy schema validation?

Saw this option when I made a linked server

Read More
sql-server-2008 linked-server
Linked Server failing on SQL Server job

I have a linked server that perfectly works when executing a query. But when I place the query in a …

Read More
sql sql-server jobs linked-server
Distributed Transaction on Linked Server between sql server and mysql

I have a table say Table1 on SQL Server 2014 and MySQL both. Table1 ID INT,Code VARCHAR(100) I created a …

Read More
mysql sql-server linked-server distributed-transactions
Execute sybase stored procedure as linked server procedure sql server 2008

EDIT The final goal is to call a stored procedure hosted in sybase with input and output parameters from SQL …

Read More
sql sql-server tsql linked-server sybase-asa
Access to the remote server is denied because the current security context is not trusted

I have a service broker which calls a stores procedure sp_dequeue queue --> ACTIVATION ( STATUS = ON, MAX_QUEUE_…

Read More
sql-server-2005 linked-server service-broker