The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.
When running a SQL statement or a stored procedure on a database, can you connect to an external database and …
sql sql-server database tsql linked-serverI have the linked server set up in SQL Server 2008. But I could not run any query against the linked …
oracle sql-server-2008 linked-serverI am currently running a third-party software suite, which uses SQL Server as its database. I have a second instance …
sql-server odbc oledb linked-serverI try to access an Excel file in SSMS. After searching the internet, I could not get it working. Here …
sql sql-server-2008 tsql oledb linked-serverI had a query with a set of parameters that needed to be run multiple times with different parameters, so …
sql-server-2008 permissions linked-server openquery sp-executesqlSQL Server 2008 Linked Server and ad-hoc INSERTs cause a rapid memory leak which eventually causes the server to become non-responsive …
sql-server-2008 memory-leaks oledb linked-serverI have a local SQL Server 2008R2. I have configured Linked Server to a remote database. The Linked Server works …
sql sql-server security linked-serverI am trying to query a MySQL linked server using SQL Server. The below query runs just fine. SELECT * FROM …
mysql sql-server linked-server openqueryIm trying to execute a stored procedure and simply insert its results in a temporary table, and I'm getting the …
sql sql-server sql-server-2005 linked-server sqlncliWe have a MS SQL Server 2005 installation that connects to an Oracle database through a linked server connection. Lots of …
sql-server oracle linked-server case-insensitive openquery