linked-server
View linked server dependencies sql server 2008
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[详细]
2023-03-15 07:41 分类:问答Can I create a linked server in sql server 2005 whose target is sql server 2000 (sp3 )?
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[详细]
2023-03-14 17:52 分类:问答Calling a SQL Server stored procedure from postgres
Is there any way to call a remote stored procedure on SQL Server from postgres 开发者_开发百科?[详细]
2023-03-14 17:41 分类:问答What are the drawbacks of using linked servers in SQL Server?
Are there any huge performance issues or securi开发者_StackOverflow社区ty concerns? Using SQL Server 2005 and higher[详细]
2023-03-14 06:23 分类:问答Restore a Linked Server from backup
A linked server has been (accidentally) removed from a SQL Server instance and nobody knows the credentials to r开发者_如何学Ce-create it from scratch.[详细]
2023-03-13 08:40 分类:问答SQL Server Linked Server during Development
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).[详细]
2023-03-09 02:19 分类:问答SQL Server 2000 - Linked Server
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[详细]
2023-03-05 04:44 分类:问答Inconsistent Error Messages When Querying Linked SQL Server
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[详细]
2023-03-03 18:15 分类:问答Where is the bottleneck / what are the gotchas when selecting records from a remote (linked) SQL server?
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[详细]
2023-03-03 06:26 分类:问答How to connect to different data bases in One DB server but with different instances?
How can I connect t开发者_运维技巧o different databases in one Db server but with different instances?[详细]
2023-03-02 09:54 分类:问答
加载中,请稍侯......