September 16, 2010 at 1:54 am
Hi all,
About OPENROWSET and OPENDATASOURCE SQL Server Books Online say:
"Enable OPENROWSET and OPENDATASOURCE support
If checked, the instance of the Database Engine supports the use of the OPENROWSET and OPENDATASOURCE functions to run remote queries without first defining a linked server. OPENROWSET and OPENDATASOURCE are designed for infrequent queries. If your applications do not use these functions, you should not enable them."
I have the next question. Somebody know why microsoft recommend (if possible) not to use OPENROWSET and OPENDATASOURCE? Exist any especial reason?
Thanks in advance.
September 16, 2010 at 11:07 am
OPENROWSET and OPENDATASOURCE are used for accessing remote OLEDB resources. They should be used only if they are accessing the remote OLEDB resources infrequently.
If you are frequently accessing remote OLEDB resources they it is better to use a linked server.
With OPENROWSET and OPENDATASOURCE the login info inclusing the passwords need to be provided everytime we use them.
You can avoid this by creating a linked server and using it for the remote queries. Also with linked servers you can have better security mgt and also you can query the catalog information.
MS recommends LS bcs they are more secure.
Thank You,
Best Regards,
SQLBuddy.
September 17, 2010 at 4:15 am
It is very clear.
Thank you very much.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply