Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
corvalion
Starting Member
6 Posts |
 Posted - 2008-02-11 : 09:05:18
|
| I am trying to do this.declare @password nvarchar(50)set @password='34958tosdgfkh##38'OPEN SYMMETRIC KEY CreditCards_Key11 DECRYPTION BY CERTIFICATE Sales09 withPASSWORD = @password;but does not like the @password in last section but if I put the actual password in that section it works, so the question is how do I asign a paramater to this ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-11 : 09:06:27
|
| Seems like you need to use dynamic sql |
 |
|
|
corvalion
Starting Member
6 Posts |
Posted - 2008-02-11 : 09:32:16
|
| in a procedure in 2005 |
|
|
|
|
|
|
OPEN SYMMETRIC KEY question