危险使用Linked Server? (SQL Server 2008) [英] Is dangerous use Linked Server ? (SQL Server 2008)
本文介绍了危险使用Linked Server? (SQL Server 2008)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
危险使用Linked Server吗? (SQL Server 2008)
Is dangerous use Linked Server ? (SQL Server 2008)
推荐答案
不,请参阅:
* [MSDN]创建链接服务器(SQL Server数据库引擎) [ ^ ]
* {youtube] sql server 2008链接服务器 [ ^ ]
通过创建链接服务器,您可以处理来自多个来源的数据。链接服务器不必是SQL Server的另一个实例,但这是常见的情况。
干杯,
C
Nope, see:
* [MSDN] Create Linked Servers (SQL Server Database Engine)[^]
* {youtube] sql server 2008 linked server[^]
By creating a linked server, you can work with data from multiple sources. The linked server does not have to be another instance of SQL Server, but that is a common scenario.
Cheers,
C
不,它本身并不危险
如果被滥用,它可能会导致问题......请参阅此博客关于链接服务器的不良做法 [< a href =http://sqlblog.com/blogs/linchi_shea/archive/2009/11/06/bad-database-practices-abusing-linked-servers.aspxtarget =_ blanktitle =New Window> ^ ]
这里讨论链接服务器 [ ^ ]
Google还有更多。
No it is not "dangerous" per se
It can however lead to problems if abused... see this blog on bad practices with linked servers[^]
And here is a discussion on the pros and cons of linked servers[^]
Google has many more.
这篇关于危险使用Linked Server? (SQL Server 2008)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文