Buradasın
SQL Server Linked Servers Overview
azure.microsofts.workers.dev/en-us/sql/relational-databases/linked-servers/linked-servers-database-engineYapay zekadan makale özeti
- Core Features
- Linked servers enable SQL Server to access remote data sources and execute commands
- Available in SQL Server and Azure SQL Managed Instance, not Azure SQL Database
- Supports distributed databases and database sharding without custom code
- Components and Configuration
- Requires OLE DB provider and data source definitions
- Microsoft OLE DB Driver (MSOLEDBSQL) is default since SQL Server 2019
- Data source provider must be on same server as SQL Server instance
- Supports Active Directory pass-through authentication with full delegation
- Management
- Can be created using sp_addlinkedserver or managed through Management Studio
- Linked servers can point back to original server for testing
- Requires four-part table names for data source references
- Supports SQL Agent jobs with Microsoft Entra authentication
- Azure SQL Managed Instance Integration
- Supports both SQL authentication and Microsoft Entra ID authentication
- Requires SQL trust group membership for Microsoft Entra authentication
- Limited to specific OLE DB driver versions and Microsoft Entra tenants