I want to call a method of the .net System.Security.dll in sqlserver script to perform some task. <BR><BR>Is it something to do on registering the class in sqlserver? <BR><BR>Thanks in advance, <BR>Ben <BR>
> I want to call a method of the .net System.Security.dll in sqlserver script to perform some task.<BR><BR>what task? what is it you're trying to achieve?<BR><BR><BR>j<BR>http://rtfm.atrax.co.uk/
Currently I do not believe there is a way to call any .Net object, class or method from within SQL Server 2000 or earlier. The rumor I have been hearing is that the next release of SQL Server will actually have the stored proc scripting language be .Net capable. Like I said this is just a rumor I have heard and know zero details.<BR><BR>Solution: Assuming that as this is the ASP.NET board that you are working with code-behind. Why don't you compute the hash in the code behind and pass that value as a parameter to the stored proc instead of passing un-hashed value to the stored proc?
Indirect :: Call a method of a .net class in sqlse
You can do it indirectly.<BR>There are ways to call COM components from SQL Server sp's.<BR>You would need to create a .Net component, build a COM wrapper for it and then use that COM wrapper from the sp.<BR><BR>