June 11, 2007 at 1:16 am
June 11, 2007 at 2:01 am
OPENROWSET makes a connection to the remote server only for the period that connection requesting is open where as LINKED server is configured to access the remote server anytime and this would be a permanent configratuion until removed from the list of servers.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 11, 2007 at 2:10 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply