what is the purpose of creating view is sql server 2000
Views are used to select particular columns from a table which is residing in a different DB. Once views are crerated we can access the view to get the specified column details from the table which is present in a different DB