472,143 Members | 1,578 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

How to call DLL file from sql server 2005

How to call a DLL file from sql server 2005

and how to use it function.... using sql server 2005
Jul 25 '10 #1
3 3625
465 Expert Mod 256MB
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:

    Expand|Select|Wrap|Line Numbers
    1. use master
    2. Go
    3. 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 :)
Aug 2 '10 #2
Thanks For the POST


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..

Your Follower..
Aug 11 '10 #3
32,499 Expert Mod 16PB
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.
Aug 11 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.