Is it possible to create view in my database server of another servers database table?
Let’s say you have a database called
and you have another database
. Is it possible to create view of
Also, I am using SQL Server 2008.
Please let me know if you have any questions.
Yes, you can. First, you need to link to the other server, using something like
Then you can access the data using 4-part naming. Here is an example:
create view v_server1_master_tables as select * from server1.master.information_schema.tables;