title: Multitenancy and Partitaioning
body: <p>HI There,</p>
  
  <p>i have to make my application SAAS compliant .For achieving multi tenancy , i was thing of partitioning the data , and each partition will be for a tenant. and this partitioning will be done dynamically .  </p>
  
  <p>has anybody done something like this ?
  what do you think the better approach be ?</p>
  
  <p>i am using SQL 2005</p>
  
  <p>Regards
  DEE</p>