I am somewhat a newbie to SQL Server administration as I am now doing everything for a very small company.
I have a database the has the need for 2 "Organization" tables. One is a "Customer Organization" table (What organization the customer belongs to). The other is a "Global Organization" table. Let's accept that they have to be different tables.
Within a database, what are the ramifications between the 2 sets of names:
And what is the ramification of making a separate database (when would I do that)?
Database : myCompany
Database : Global
Any advise would be appreciated,