Problem with encryption

• maykabog

  SSC-Addicted

  Points: 446

  More actions

  September 17, 2008 at 10:38 pm

  #198247

  Hi,

  I can't execute any of encryption commands.

  For example,when I write :

  CREATE CERTIFICATE ElmerEncryptionCertificate

  WITH

  SUBJECT = 'Elmer Certificate',

  EXPIRY_DATE = '01/01/2006 '

  I receice :

  Incorrect syntax near 'CERTIFICATE'.

  I have installed SP2.

  Can anyone help me pls?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 18, 2008 at 1:49 am

  #873423

  Check that the database you're running it in is in compatibility mode 90.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• maykabog

  SSC-Addicted

  Points: 446

  More actions

  September 18, 2008 at 2:43 am

  #873446

  Hi,thanks for replay.

  When I tryed to change to compatibility 90,I get message that valid modes are "60,65,70 or 80".

  What I have to do in order to change it to 90?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 18, 2008 at 4:44 am

  #873487

  Please don't cross post. It just wastes people's time and fragments replies.

  No more replies to this thread please. Direct replies to:

  http://www.sqlservercentral.com/Forums/Topic571477-146-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass