InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 17:55:55 GMT20http://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxPlease run the following and post the results:SELECT @@VersionThu, 18 Sep 2008 04:42:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxreally I did not understand what is your problem.Thu, 18 Sep 2008 04:15:13 GMTRajesh kasturihttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxDatabase test existThu, 18 Sep 2008 02:36:11 GMTmaykaboghttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxmay be you do not have test database in your server. use your database name in place of test. or execute the below statementCREATE DATABASE testThu, 18 Sep 2008 00:46:37 GMTRajesh kasturihttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxAre you new to SQL Server.Thu, 18 Sep 2008 00:45:11 GMTRajesh kasturihttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxI tryed to execute step 1 and reseive this message:Incorrect sysntax neas MASTERThu, 18 Sep 2008 00:25:50 GMTmaykaboghttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxPlease execute the below script step by step and let me know where the scrip is getting fail.--Step 1: Create database masterkey for TestUSE TestCREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Raj3sH'--Step 2: Create database certificate CREATE CERTIFICATE Certificate1 WITH SUBJECT = 'Test'--Step 3: Create a symetric key encrypted by the certificateCREATE SYMMETRIC KEY TestKey09 WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE Certificate1;GO--Step 4: Create a Column in which to store the encrypted dataCREATE TABLE TEST (ID VARCHAR(80), EncrypIDN varbinary(128))goALTER TABLE TEST ADD EncrypIDN varbinary(128)--Step 5: Open the symetric key with which to encrypt the dataOPEN SYMMETRIC KEY TestKey09 DECRYPTION BY CERTIFICATE Certificate1;--Step 6DECLARE @I INTSET @I = 100WHILE @I <>0BEGIN INSERT INTO TEST(ID) VALUES(@I) SET @I = @I -1ENDGOUPDATE TEST SET EncrypIDN = EncryptByKey(Key_GUID('TestKey09'),ID)--Step 7: Open the symetric key with which to decrypt the dataOPEN SYMMETRIC KEY TestKey09 DECRYPTION BY CERTIFICATE Certificate1;--Step 8: Compare the dataSELECT ID, EncrypIDN, CONVERT(varchar,DECRYPTBYKEY(EncrypIDN)) FROM TESTRegardsRajesh KasturiThu, 18 Sep 2008 00:12:38 GMTRajesh kasturihttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxI do not think you need to do some thing with sp or operating system. Please tell me little bit more what is the exact problem you are facing.Wed, 17 Sep 2008 23:59:10 GMTRajesh kasturihttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxHi,thanks for your replay,but it didn't help me.I think that there is a problem with some settings.Maybe I have to install some service pack?Or to do something in operating system?Wed, 17 Sep 2008 23:51:17 GMTmaykaboghttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxYou are giving expiry date '01/01/2006' Execute as below it will be okCREATE CERTIFICATE ElmerEncryptionCertificate WITH SUBJECT = 'Elmer Certificate', EXPIRY_DATE = '01/01/2009'RegardsRajesh KasturiWed, 17 Sep 2008 23:16:39 GMTRajesh kasturihttp://www.sqlservercentral.com/Forums/Topic571477-146-1.aspxHi,I can't execute any of encryption commands.For example,when I write :CREATE CERTIFICATE ElmerEncryptionCertificate WITH SUBJECT = 'Elmer Certificate', EXPIRY_DATE = '01/01/2006 'I receice :Incorrect syntax near 'CERTIFICATE'.I have installed SP2.Can anyone help me pls?Wed, 17 Sep 2008 23:07:13 GMTmaykabog