We are trying to use Database Encryption Tool: DBDefence for SQL Server 2008 (http://www.dbdefence.com/
), once any Database is Encrypted it requires to have following kind of SQL statement to be executed.
OPEN SYMMETRIC KEY DBDX DECRYPTION BY PASSWORD = ‘...’
this will enable Database access for particular Connection,
Kindly advise how we can use this with Open Access, I tried to run this after NewObjectScope by scope.GetSqlQuery(script)
and also by ExecuteDDLScript but it did't worked.. Access is not granted, seem that I need call this anywhere else. Please advise.