Policy Based Management (DMF)

• arvindravish

  Say Hey Kid

  Points: 671

  More actions

  January 2, 2009 at 11:58 pm

  #197648

  Is it possible to have case sensitive table naming policy in SQL Server 2008.

  For example. In a datawarehouse I want all dimension tables to have a name starting with Dim(should be case sensitive, D in capital case)

  I tried creating a table naming policy for this.But it allows table names starting with dim, DIM also which is not what I want.

  I want the policy to prevent table creation if the table name does not start with Dim( even if it DIM or dim or dIM or any other combination)

  Is there any work around for this OR is it the limitation of the feature?

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  January 4, 2009 at 7:30 am

  #920850

  Change condition to where Table Name = Upper(Name) and then evaluate the policy against your database.

  MJ

• arvindravish

  Say Hey Kid

  Points: 671

  More actions

  January 4, 2009 at 8:34 pm

  #920946

  Hi Manu,

  Thanks for your reply.

  According to you if I use Upper(Name) then the policy will allow only if all the letters in 'dim' are DIM for a table name DIMCustomer.

  But what I want is the table name should be start with Dim.

  Be careful here. I want only D (in Dim) in capital case and im(in Dim) to be in smaller case.

  To be more accurate the name should follow camelcase convention.

  I sit possible to do it this way?:D