Buradasın
Setting Up SQL Server Linked Servers
databasejournal.com/ms-sql/setting-up-a-linked-server-for-a-remote-sql-server-instance/Yapay zekadan makale özeti
- Basic Concept
- Linked servers allow queries to be submitted on one server and processed on another
- Queries can be distributed across multiple SQL Server instances
- Objects referenced using four-part naming convention: server.database.schema.object
- Setup Process
- Linked servers can be defined in SQL Server Management Studio
- Security settings control authentication methods and login mappings
- Server options manage collation compatibility and connection times
- Authentication Options
- Local logins can be mapped to remote SQL Server authenticated users
- Multiple local logins can be mapped to single remote login
- Connection options include "Not be made" and "Be made without security context"
- Usage
- Linked servers enable joining data from multiple SQL Server instances
- Single TSQL statement retrieves data from different instances
- Objects referenced using linked server name followed by period