Thanks guys for all the input...you have given me alot to go back with and inform that we should stick with the existing database instead of trying to split and...
And that's what I was looking for guys...thanks for the input. It was a suggestion that a web developer had...but I was not completely sold on the idea and...
We are currently in the process of implementing CRM...so the opportunity to split some of the data/tables from our SQL db will be moved into the new CRM db. ...