Has anyone successfully created a view across servers? I have 2 servers DB1 & DB2. I create a view on DB1 that accesses a table on DB2. It allows me to view it, however, if I try to change or delete a record, it says the object does not exist. Is there some special or different way for creating a view that goes across servers?

Any assistance is appreciated