The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P75: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 352 Chapter 8 ETL Techniques To create a linked server you use the sp_addlinkedserver stored procedure. This procedure allows you to specify the name of the linked server which OLE DB provider should be used and some basic information about the linked server. This procedure has to be run before you can configure the linked server further. Once the linked server exists you can set some options on it using the sp_serveroption stored procedure. The sp_serveroption stored procedure allows you to specify which collations are to be used when dealing with character data connection time outs and more. By setting the Data Access option to true you enable SELECT INSERT UPDATE and DELETE statements with the linked server. The RPC and RPC OUT options allow remote procedure calls RPCs with the linked server. Exam Warning_ V Remember that if the Data Access option isn t set to true you can t run SELECT INSERT UPDATE or DELETE statements against the linked server. Also the RPC and RPC OUT options enable the use of stored procedures between the linked servers. Finally you have to decide how users will connect via the linked server. You do that using the sp_addlinkedsrvlogin procedure. It is through the @rmtsrvname @ useself @locallogin @rmtuser and @rmtpassword parameters of this procedure that you can control who users on a local system connects as when they attempt to connect to the remote server. You can use various combinations of the parameters to imply a default account that is used for all local users on the remote system require that local users have matching accounts on the remote server impersonation or perform individual mapping of a local user to a specific set of credentials for the remote system. The following script creates a linked server to allow convenient access to the WebSQL server you worked with earlier. It will then configure impersonation as the log-in mechanism. That means that any local user who
