The Provider string can contain any valid connection properties the provider supports Connection properties are separated by a semicolon In the example below the 'Default Collection' property is used This is the default library that you connect to In SQL Server 05, you can test your linked server by running a simple query 1 SQL Server offers many built in metadata functions and one of these functions, @@OPTIONS which allows you to get the current values that are set for the current session When each connection is made the default values are established for each connection and remain set unless they are overridden by some other processConnection options have a default value that you can override by defining the new value in the connection string (classic MySQL protocol and X Protocol) or in the URIlike connection string (X Protocol) Connector/NET option names and synonyms are not case sensitive
Ms Sql Setup With Sql Server Management Studio Appspace Core V5 9 Documentation
