>Hi how can i instantiate .NET class in SQL Store Procedure? it is possible? thanks

In SQL 2000, this is not possible. In SQL 2005 Beta 2, you can add a .NET assembly to a database and reference the classes in it.