Point out the correct statement :
A. To access a mirrored database, a connection string must contain the database name
B. When the linked server is defined against an instance of SQL Server, catalog refers to the default database to which the linked server is mapped.
C. [ @location= ] ‘location’ is the location of the database as interpreted by the OLE DB provider in sp_addlinkedserver
D. All of the mentioned
Answer:A
Point out the correct statement :
A. To access a mirrored database, a connection string must contain the database name B. When the linked server is defined against an instance of SQL Server, catalog refers to the default database to which the linked server is mapped. C. [ @location= ] ‘location’ is the location of the database as interpreted by the OLE DB provider in sp_addlinkedserver D. All of the mentioned
Explanation:Location parameter is passed as the DBPROP_INIT_LOCATION property to initialize the OLE DB provider.