Another future of Sql Server a part from linked server to access data from another instance of sql server is to use the OpenRowset function ,this future allows for accessing data from another instance of sql server , but requires you to specify the connection details every time when you want to use to .
For accessing the data using OpenRowset function sql server needs to configure advanced options and than enable adhoc distributed queries as shown below
it is important to note that, there should be only single space between each word of Ad Hoc Distributed Queries or else the query will fail
For accessing the data using OpenRowset function sql server needs to configure advanced options and than enable adhoc distributed queries as shown below
it is important to note that, there should be only single space between each word of Ad Hoc Distributed Queries or else the query will fail
No comments:
Post a Comment
Note: only a member of this blog may post a comment.