A database can have a DMK - Database Master Key
@@IDENTITY - last inserted identity value
SCOPE_IDENTITY() - last inserted identity value within the scope
SQL Server has two kinds of keys: symmetric and asymmetric.
Symmetric keys use the same password to encrypt and decrypt data.
Asymmetric keys use one password to encrypt data (called the public key) and another to decrypt data (called the private key).
You cannot back up and restore individual asymmetric keys
http://www.dnnsoftware.com/community-blog/cid/154944/check-and-upgrade-sql-database-compatibility-level-before-upgrading-to-dnn-7x-using-dnn-sql
@@IDENTITY - last inserted identity value
SCOPE_IDENTITY() - last inserted identity value within the scope
SQL Server has two kinds of keys: symmetric and asymmetric.
Symmetric keys use the same password to encrypt and decrypt data.
Asymmetric keys use one password to encrypt data (called the public key) and another to decrypt data (called the private key).
You cannot back up and restore individual asymmetric keys
http://www.dnnsoftware.com/community-blog/cid/154944/check-and-upgrade-sql-database-compatibility-level-before-upgrading-to-dnn-7x-using-dnn-sql
No comments:
Post a Comment