Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Call csharp from Sql-Server

Author  Topic 

antcasq
Starting Member

2 Posts

Posted - 2006-09-04 : 09:03:47
Can I call a csharp method of my custom class from Sql-Server Stored Procedure?

If it's possible can anyone provide some sample code or the configuration required?

Thanks

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-09-04 : 09:15:40
Are you talking about SQL Server 2000 or 2005?

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-09-04 : 09:18:01
see if this article helps you..

http://www.sqlteam.com/item.asp?ItemID=21927

Chirag
Go to Top of Page

antcasq
Starting Member

2 Posts

Posted - 2006-09-04 : 15:05:09
I'm using SQL Server 2005.

I will look into the article. It seams to do the job.
Thanks
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2006-09-05 : 08:08:22
You'd need to write a C# CLR assembly, then deploy it to sql server. You can write procedures or functions in this way and then call them using normal T-SQL commands.

-------
Moo. :)
Go to Top of Page
   

- Advertisement -