We are using MS sequel server and have a production data base provided by a third party. We need to create additional views, stored procedures and even some customized tables.

My question is: Could we put those in a "customized" data base and still be able to access tables in the prodiction data base? If so, how would a sp or view located in the "customized" db know to look for tables in the "production" db. In my vb program do I need to connect to both data bases and call the sp in the customized data base and it will find the table(s) in the production data base? Also If I have a table in both customized and production data base that need to be part of same sp will that be a problem?