>Is there a way to copy a view from one database to another, assuming the second database has all the necessary tables with all the right fields?
Open the view, right click to see the code, copy the code. Than in commnad window :
Open database dSecondDb
create sql view
as
cetin