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?
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
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
See also exec xp_msver
from http://www.eggheadcafe.com/software/aspnet/33624951/query-to-determine-which.aspxPremature optimization is the root of all evil in programming. (c) by Donald Knuth
