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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-04 : 08:28:02
|
| Bhushan writes "I want to execute C# class/function depending on any updates to the database tables in SQL server 2000, so can it be possible by writing UDF in sql, if yes how?or any other way to handle this from SQL.its Urgent...Thanks if u help me out by giving example. " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-04 : 08:33:27
|
| It is possible, but you have to write an extended stored procedure to provide access to C# functions. One potential problem is that you MUST write a wrapper class in C++ in order to do it. I don't have the details, I'm basing this on a presentation given by a developer in the Atlanta area a while back.In any case, what does the C# code do exactly, and are you sure you really need it? Is there a way to perform these actions in T-SQL or a scripting language? Or can it be written as a COM object and called using sp_OACreate and the like? There are a lot of things you can do here that can work much more easily. |
 |
|
|
|
|
|
Writing UDF in MS-SQL 2000 which calls C# class.