Does any know how / if it is possible to view all tables/views/stored procedures that depend on a linked server in Sql Server 2008. Basically as if the context menu \"View dependencies\" was accessibl
Is it possible to create a linked server 开发者_JS百科in SQL Server 2005, which links to a SQL Server 2000 SP3?Yes it is possible. Check the link http://msdn.microsoft.com/en-us/library/ms188279(v=SQL
Is there any way to call a remote stored procedure on SQL Server from postgres 开发者_开发百科?
Are there any huge performance issues or securi开发者_StackOverflow社区ty concerns? Using SQL Server 2005 and higher
A linked server has been (accidentally) removed from a SQL Server instance and nobody knows the credentials to r开发者_如何学Ce-create it from scratch.
I am creating a SQL Server database (call it a) on my development system (call it A), which nee开发者_StackOverflow社区ds data from another production-database-server (b, on Server B).
For our application, 开发者_JAVA百科we using SQL Server 2000 & MySQL. I want to update the MySQL database if any modifications in SQL Server 2000. For this, I have created the Linked Server for My
I\'m building a data warehouse that queries databases that are sometimes located on linked servers. When executing some queries, I have occasionally encountered the following error message
I\'m in a satellite office that needs to pull some data from our main office for display on our intranet.We use MS SQL Server in both locations and we\'re planning to create a linked server in our sat
How can I connect t开发者_运维技巧o different databases in one Db server but with different instances?