This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
I have 2 server which is server1 and server2
i just want copy of the view from server 2 and same to be in server1.
the main thing is, i don't want all the tables and views. i just want only one view from server2 and same to be reflected in server1.
Is it possible to create view without using linked server..?
Example:
Server2 :
TESTDB ==>
dbo.view1
dbo.view2
I want to fetch view from (server2 ==> TESTDB ==>dbo.view2)
Note : if i use linked server, the other person may be able to see all the db,tables and views. we just want to restrict.
Additional SQL Server features and topics not covered by specific categories
Answer accepted by question author
Is it possible to create view without using linked server..?
Instead of a Linked Server (which should be preferred for your requirement) you can use OPENROWSET (Transact-SQL) ; which is a kind of ad-hoc Linked Server.
even if we use linked server, can we connect only particular view...????
It's called "Linked Server" because it points to a server, not to a particular database nor objects.
Which objects can be accessed depends on the given permissions for the logon; so grant only SELECT permissions for the view.