patrickmcginnis59 (9/13/2012)
The approach of applications having their own databases is probably the norm
Perhaps, perhaps not. But is that a good way to do it, regardless of how common it is?
Remember, you can use different schemas in the same db. This gives you separation for security and other purposes, but still allows you to use FK constraints, etc..
Kind of like two databases in one;-) !
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.