I tend to create a view in the first database to access the second. Helps if I need to move things by abstracting. Also doesn't tie my code to some database name (other than the view).

Same security items brought up above still apply.

Steve Jones

sjones@sqlservercentral.com

http://qa.sqlservercentral.com/columnists/sjones

http://www.dkranch.net