Thanks Erland.

jim

"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns93BDF40865EFDYazorman@127.0.0.1...
> Jim Bailey (jim12345@jbaileygroup.com) writes:
> > Has anyone tried to utilize managed code from SQL Server 2000 ? I'd
> > like to utilize System.Encryption classes from SQL Server to
> > encrypt/hash some data (passwords etc).
> >
> > I remember reading somewhere about accessing COM objects from from a
> > script, but if I wrap this thing in COM, I loose one of the great
> > features of .NET - NO COM objects to horse around registering and
> > managing !
>
> To call external from SQL Server, you have two choices: 1) extended
> stored procedure. 2) COM objects through sp_OAxxxx routines. In none
> of the cases you can call managed code directly, but you would need a
> COM interop or somesuch.
>
> Now, in next version of SQL Server, codenamed Yukon, you will be able
> to program in .Net within SQL Server itself. However, MS does not
> expect Yukon to be available until the second half of 2004.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
>