We have a need to have a view be able to reference columns in another database on another MS SQL 2000 server. Is that going to require linked servers, or is there another syntax or facility? Thanks!

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...