The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.
On my SQL 2005 server, I have a linked server connecting to Oracle via the OraOLEDB.Oracle provider. If I run …
sql-server-2005 tsql linked-serverSaw this option when I made a linked server
sql-server-2008 linked-serverI have a linked server that perfectly works when executing a query. But when I place the query in a …
sql sql-server jobs linked-serverI have a table say Table1 on SQL Server 2014 and MySQL both. Table1 ID INT,Code VARCHAR(100) I created a …
mysql sql-server linked-server distributed-transactionsEDIT The final goal is to call a stored procedure hosted in sybase with input and output parameters from SQL …
sql sql-server tsql linked-server sybase-asaI have a service broker which calls a stores procedure sp_dequeue queue --> ACTIVATION ( STATUS = ON, MAX_QUEUE_…
sql-server-2005 linked-server service-brokerI know I can do the following: EXEC Server_Name.DBName.sys.sp_executesql N'TRUNCATE TABLE dbo.table_name' But …
sql-server tsql linked-server synonym sp-executesqlI'm working with SQL Server Express, I created a linked server to an Oracle database. As the title indicates, I …
sql-server oracle tsql linked-server openqueryI have a WebTrends ODBC source on server1 and a SQL Server 2005 on server2. I want to connect to this …
sql-server sql-server-2005 odbc linked-server webtrendsI have a table called Table with columns: ID (int, primary key, clustered, unique index) TEXT (varchar 15) on a MSSQL …
sql-server tsql performance linked-server openquery