create/import policy on sql 2005

  • i have created a policy on sql 2008 now i need to apply that

    policy on sql 2005 server. is that possible?

    i can evaluate this policy on sql 2005 server from central management server

    I am not able to import it to SQL 2005 because it gives error..which is obvious..

    but i need to create it on sql 2005 itself.So can i create it?

  • dallas13 (3/18/2009)


    i have created a policy on sql 2008 now i need to apply that

    policy on sql 2005 server. is that possible?

    No. Policies are a 2008 feature.

    You can evaluate a policy stored on 2008 against a 2005 server, but 2005 doesn't know what policies are and cannot import, store or run them.

    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 2 posts - 1 through 1 (of 1 total)

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