Linked Server

[accessman2]

Hi,

I have 2 databases, db1, db2 in the SQL Server. In db1, I created the view to link one table from db2. When I run it, it is just read-only, I want to edit/insert data in the view. Can we edit/insert the data in the view from db1(which linked table from db2)?

 

[pdx_man]

You cannot edit/insert data in a view. It is just that, a view of the data.