locked
Determine whether AES_256 exists RRS feed

  • Question

  • Hi folks

    Within my DB deployment I need (sometimes) to create a new key with the algorithm AES_256, which is not available on Win XP.
    I use Win XP as isolated development environment and Win 2003 Server on all staging / productiv servers.
    How can I determine within a T-SQL script, whether AES_256 Algorithm exists or on which OS the SQL Server resides?

    Thanks for your help
    Aine
    Monday, January 18, 2010 3:36 PM

Answers

  • You can simply get the OS version with
    select @@Version as part of it.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by Aline.Z Tuesday, January 19, 2010 7:41 AM
    Monday, January 18, 2010 3:37 PM

All replies

  • You can simply get the OS version with
    select @@Version as part of it.
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Marked as answer by Aline.Z Tuesday, January 19, 2010 7:41 AM
    Monday, January 18, 2010 3:37 PM
  • See also exec xp_msver from http://www.eggheadcafe.com/software/aspnet/33624951/query-to-determine-which.aspx
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Monday, January 18, 2010 3:42 PM
  • thanks Naom
     @@version works perfect for me.
    Tuesday, January 19, 2010 7:41 AM