How to Call a c#.net class from stored procedure

Hi,

I would like to know how can I call a c#.net class from a stored procedure.

I have a class file which will generate a pdf file from sql reporting services and mail that file. Now I want to call this class from a stored procedure. Is it possible, if so please send me the sample code.

Thanks in advance

Regards

Babu

Which version of SQL Server are you using ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

SQL Server 2005

|||

Please take a look at the SQLCLR samples in the setup cd. Or you can also look at the examples in Books Online. You can create a SQLCLR stored procedure for example to do this. You can start at the link below:

http://msdn2.microsoft.com/en-us/library/ms131102(SQL.90).aspx