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.