InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 13:20:14 GMT20http://www.sqlservercentral.com/Forums/Topic720598-359-1.aspxYes. My manager though is having none of it - thank God!!I guess this person has done some programming in the past - those are the folks that scare me.They seem to know just enough to be dangerous and also have a mgrs ear. Thankfully my mgr also still codes so she's not out of touch.Wed, 20 May 2009 12:55:55 GMTdinovotpahttp://www.sqlservercentral.com/Forums/Topic720598-359-1.aspxDo you mean to say each database for indivisual client on the same instance???Wed, 20 May 2009 10:56:35 GMTPradyothana Shastryhttp://www.sqlservercentral.com/Forums/Topic720598-359-1.aspxThe company where I am working is growing. We are bringing on more Clients and someone suggested that we'll need more databases (maybe 1 for each. client) - yea my heart stopped for a sec. Not a great idea if you have thousands of clients huh? yea not gonna take that approach.Well I know there has to be someone out there who has encountered this situation.Where I used to work someone put a CompanyID column in ea. table to segragate the data by Company.If anyone has information of different approaches. Pros/Cons etc it would be greatly appreciated.Thanks,Mark.Wed, 20 May 2009 08:29:33 GMTdinovotpa