How to call DLL file from sql server 2005

[MrMob]

How to call a DLL file from sql server 2005

and how to use it function.... using sql server 2005

[PsychoCoder]

You have two options for accomplishing this:

1. Extended Stored Procedures:
   You can use the procedure sp_addextendedproc (located in the system database) to register the DLL, then you can call it. This is an example of how it works:
   
   

   use master
   Go
   sp_addextendedproc "MyFunction", "C:\Windows\MyDLL" 
    

   NOTE: Keep in mind that this method is Deprecated but you can accomplish it this way
   
2. CLR Objects:
   You can create CLR objects in .Net; such as stored procedures, user defined functions, etc, then register it on your SQL server as an assembly

Hope that helps :)

[MrMob]

Thanks For the POST

Richard..

I will be Happy Enough i get any Clue to use
the Dll File and it Function..

iN sql server 2005

with some good Examples..

Thankyou..
Your Follower..
MrMob...

[NeoPa]

MrMob: I will be Happy Enough i get any Clue to use
the Dll File and it Function.

You should be happy then, as Richard provided that and more.

You should understand that we're not here to do your work for you. You have the pointers. If that's still not clear then please explain carefully and clearly what you don't understand.