you can create a view, but Not with schemabinding.
Tables and user-defined functions must be referenced by two-part names in the view. One-part, three-part, and four-part names are not allowed.
since a differnet database is referenced via a three part name, for example, and since there's no way to create true referential integrity accross multipel databases in SQL server, it's not possible with schemabinding.
I have a similar need.
The view points at a table (a table that stores daily currency exchange rates) in a different database (the master database that stores all shared data).
Replies in this thread are confusing.
In short, can you create a view WITH SCHEMABINDING to a table in a different database?
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!