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

  • Thread starter Thread starter Sara
  • Start date Start date
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
 
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
 
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
 
| 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB.Net & SQL2005 Stored Procedures 1
Procedure names ;1 4
DLL for XML Data Transfer 5
Call .Net Method from VC++ 15
What are the steps to fix damaged MDF files in SQL Server? 0
LINQ to SQL - JOIN of tables stored on different servers 2
How to call C# dll from sql server 2000 dts? 5
Invalid Column Name Sql-Error :Executing a stored procedure 1

Back
Top