Post reply

Problem with encryption

  • 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?

  • 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

  • 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?

  • 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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply