SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:11 PM
| ||||
| ||||
 Re: Managed Code Interoperability 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      |
|
02-28-2008, 05:12 PM
| ||||
| ||||
| Re: Managed Code Interoperability 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 > |
Linear Mode
