Viewing 15 posts - 781 through 795 (of 3,738 total)
Thanks for the advise.
I will do so.
In this case I'm Truncating and re-loading the Data from an AS400 nightly.
Thanks again. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 1:43 pm
Why is it necessary to open a new session?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 1:08 pm
I'm having bad luck.
The first time I execute the following code I get the decrypted SSN:
CREATE TABLE dbo.Name_and_SSN
(Full_Name VARCHAR(50),
CLEAR_SSN VARCHAR(12));
--point_ctl.agent_support.tax_id_number
--and point_cyp same table
INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)
VALUES
('Egor Mcfuddle' ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 12:32 pm
Eirikur Eiriksson (7/17/2014)
Welsh Corgi (7/17/2014)
I did not open the Key in the new window.That was the problem.
Thanks for all the help.
Oooops! Hate to be the one to tell you but...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 11:00 am
I did not open the Key in the new window.
That was the problem.
Thanks for all the help.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 10:18 am
tripleAxe (7/17/2014)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 9:47 am
So the scope of the key is limited to a session.
That is why it does not work.
If anyone knows what I need to differently so decrypt from another session it...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 8:53 am
I recreated and opened the key. It decrypts from the same session but when I go to another session it list null.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 8:34 am
That was a great example.
I have a little problem.
I'm going to load the data and encrypt it in an SSIS Package. Data Transformation followed by an Execute SQL Task to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 17, 2014 at 8:24 am
Eirikur Eiriksson (7/16/2014)
😎
USE tempdb;
GO
CREATE TABLE dbo.Name_and_SSN
(Full_Name VARCHAR(50),
CLEAR_SSN VARCHAR(12));
INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)
VALUES
('Egor...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2014 at 11:10 pm
Thank you so much for your help.
I appreciate the criticism.
🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2014 at 7:02 pm
Ed Wagner (7/16/2014)
Welsh Corgi (7/16/2014)
Lynn Pettis (7/16/2014)
Welsh Corgi (7/16/2014)
I need o update the existing record to the encrypted...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2014 at 6:24 pm
Eirikur Eiriksson (7/16/2014)
Welsh Corgi (7/16/2014)
I started out by asking a basic question about encryption.
I am Grateful for the help and I got my answer. Then I asked about the next...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2014 at 5:37 pm
ok, I'm sorry for causing any grief.
I have SSN's in a column in a table.
I want to encrypt those values.
That would be a simple update statement?
Thank you all for your...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2014 at 5:16 pm
Lynn Pettis (7/16/2014)
Welsh Corgi (7/16/2014)
Lynn Pettis (7/16/2014)
Lynn Pettis (7/16/2014)
Welsh Corgi (7/16/2014)
I need o update the existing record to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 16, 2014 at 12:00 pm
Viewing 15 posts - 781 through 795 (of 3,738 total)