how to make sensitive data encrypted in tables

Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.Encryption is available in SQL server 2005.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.|||See if this helps:
http://www.sqlsecurity.com/FAQs/SQL...55/Default.aspx
Which version of SQL Server are you using?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
Any idea how to make sensitive data encrypted and make it readable for
applications which uses it. I mean like password in syslogins table. Is
there a way to do it in sql server or do i need to use any third party
tools. Can you please list out if there are any tools.
Thanks,
Subbu.|||We are using SQL Server 2000.
Thanks for the responses.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23B%23XkILiGHA.1276@.TK2MSFTNGP03.phx.gbl...
> See if this helps:
> http://www.sqlsecurity.com/FAQs/SQL...55/Default.aspx
> Which version of SQL Server are you using?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Any idea how to make sensitive data encrypted and make it readable for
> applications which uses it. I mean like password in syslogins table. Is
> there a way to do it in sql server or do i need to use any third party
> tools. Can you please list out if there are any tools.
> Thanks,
> Subbu.
>
>|||Then you'll have to encrypt the data before storing it in SQL Server. Check
out:
http://msdn.microsoft.com/library/d...ction-dpapi.asp
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:O0y$STLiGHA.2220@.TK2MSFTNGP05.phx.gbl...
We are using SQL Server 2000.
Thanks for the responses.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23B%23XkILiGHA.1276@.TK2MSFTNGP03.phx.gbl...
> See if this helps:
> http://www.sqlsecurity.com/FAQs/SQL...55/Default.aspx
> Which version of SQL Server are you using?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:OcHijBLiGHA.4276@.TK2MSFTNGP03.phx.gbl...
> Any idea how to make sensitive data encrypted and make it readable for
> applications which uses it. I mean like password in syslogins table. Is
> there a way to do it in sql server or do i need to use any third party
> tools. Can you please list out if there are any tools.
> Thanks,
> Subbu.
>
>

how to know time of insertion of a row

Hi
Is there a way to know time of insertion of a row without using,
timestamp,currentdate function etc. Isthere any DBCC COMMAND which gives me
the date of insertion of a row.
--
Thanks in Advance
Regards
SuparichituduNo, there isn't
However , you are be able to create a column with GEDATE() as a DEFAULT
CONSTRAINT.
CREATE TABLE Test (col1 INT,col2 DATETIME DEFAULT GETDATE())
GO
INSERT INTO Test (col1) VALUES (100)
GO
SELECT * FROM Test
"Suparichithudu" <Suparichithudu@.discussions.microsoft.com> wrote in message
news:42420237-454F-49EE-B756-21326EAADE0C@.microsoft.com...
> Hi
> Is there a way to know time of insertion of a row without using,
> timestamp,currentdate function etc. Isthere any DBCC COMMAND which gives
> me
> the date of insertion of a row.
> --
> Thanks in Advance
> Regards
> Suparichitudu
>|||if you're in the unenviable situation where you need to retrospectively
find this out, one thing that might be able to help you is if you can
get hold of the transaction logs over the period that you know it was
inserted. However that would require you to not be using a simple
recovery model.
There are some tools you can get free trials of which will query a
logfile, but I'm not sure of their reliability.