I have two databases in SQL SERVER 2000 namely PMISDB (Personnel) and PENDB (PEnsion Management). I want to create a view that select FileNo, Staffname, ************, Department from Database PMISDB for use in PENDB instead of creating a new staff record. How can I achieve this please?

use the four part naming convention
SELECT column1, column2, column3 FROM ServerName.database.dbo.tablename

you can also create a view at the server you are linked to and call that view.


Jaime E. Maccou