SQL Server 2005 has various new security features, a big improvement over the features in SQL Server 2000. The new release boasts of an enhanced authorization model, a huge set of data encryption capabilities, code signing and a much improved (no more setuser!) set of execution context features.
