By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,481 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,481 IT Pros & Developers. It's quick & easy.

How to call a .net dll method from sql server 2000 stored procdure

P: n/a
How to call a .net dll method from sql server 2000 stored procdure

Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Sare,

I think that you have for this SQL language related question much more
change in a SQLServer programmer related newsgroup.

Just my idea

Cor
Nov 21 '05 #2

P: n/a
Hi,

I do not believe it is possible with sql server 2000 but I believe
you might be able to with sql server 2005.

Ken
------------------
"Sara" <sa**********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
How to call a .net dll method from sql server 2000 stored procdure

Nov 21 '05 #3

P: n/a
well it depends on what you want
SQL 2000 can call a VS.Net assembly through notification services ( seperate
install it is a sort of callback ) SQL 2005 has this standard onboard
however if you mean calling a .Net dll like a extended stored procedure in
SQL 2000 they must be written in C++ in sql 2005 you can write them in .Net
code
regards

Michel Posseth


"Sara" <sa**********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
How to call a .net dll method from sql server 2000 stored procdure

Nov 21 '05 #4

P: n/a
"Sara" <sa**********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
| How to call a .net dll method from sql server 2000 stored procdure

you can compile it for use as a com dll. once this is done, you can create
the object in sql server and use its functionality. to do that, either
google or post to a sql server ng. using com components in sql server is
pretty straight-forward.
Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.