encrypt the data of collumn

Hi!
Is there any way to encrypt the data stored in collumn of a table ? actually
we are storing the password of all employees in that table.
Regards,
Swatiswati
Serach on internet for this subject.There were discussions at the forum a
week (or something like that) ago.
Some postes by David Portas and Steve Kass.
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:OFksBWXzEHA.1932@.TK2MSFTNGP09.phx.gbl...
> Hi!
> Is there any way to encrypt the data stored in collumn of a table ?
actually
> we are storing the password of all employees in that table.
> Regards,
> Swati
>
>|||thanks , I got the required link
Regards,
Swati
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhGjbdXzEHA.2016@.TK2MSFTNGP15.phx.gbl...
> swati
> Serach on internet for this subject.There were discussions at the forum a
> week (or something like that) ago.
> Some postes by David Portas and Steve Kass.
>
>
>
> "swati" <swati.zingade@.ugamsolutions.com> wrote in message
> news:OFksBWXzEHA.1932@.TK2MSFTNGP09.phx.gbl...
> > Hi!
> >
> > Is there any way to encrypt the data stored in collumn of a table ?
> actually
> > we are storing the password of all employees in that table.
> >
> > Regards,
> > Swati
> >
> >
> >
> >
>

Emptying Log file

I have a database with mdf size 10 gb and ldf size 8 gb. i want to
reduce the size of ldf file how can i do it.
Regards,
Farid.
*** Sent via Developersdex http://www.examnotes.net ***You can shrink transaction log size.
1. DBCC ShrinkDatabase
2. Dbcc ShrinkFile --log
3. Auto shrink option
"Ghulam Farid"?? ??? ??:

>
> I have a database with mdf size 10 gb and ldf size 8 gb. i want to
> reduce the size of ldf file how can i do it.
> Regards,
> Farid.
> *** Sent via Developersdex http://www.examnotes.net ***
>