v.basic question here! I'm a newbie
imagine you are designing an enterprise wide job tracking/billing MIS using SQL and ASP.
Is it better to have one db with lots of tables or lots of db's with fewer tables?
There are going to be data logged for many different departments and different permissions for different departments and users.
I think for security it might be easier to have seperate dbs but I'm not too sure about setting relationships between tables in different dbs???
What do all you pros think?
thanks for any tips