View Full Version : Linked Server


accessman2
04-05-2007, 08:55 PM
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
04-06-2007, 10:21 AM
You cannot edit/insert data in a view. It is just that, a view of the data.