Thanks guys...this is generally what I was looking for. Just to see what others are currently doing.

Thanks!

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...

Thanks for the tips guys...yes I picked the Accidental DBA book up earlier this week!!

And thanks benjamin; that is a great script!!

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. ...