run an external program or call another functions

• omidshf

  SSC Enthusiast

  Points: 160

  More actions

  December 8, 2011 at 12:28 pm

  #253268

  hi

  i want to execute external programs or call another functions ( inside an ocx or dll) inside sql server 2000 (for example inside a sp).

  how can i do it

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  December 14, 2011 at 1:13 pm

  #1421573

  xp_cmdshell will allow you to call some things.

  The code inside SQL Server are not the same as say the code from a C# or VB program. You don't have an interface to link to a DLL.

  What you can do is install an extended stored procedure, which can be used to link to a DLL and call it, but you want to be very careful as you are then running something in process, and could cause instability.

  You can also potentially use the sp_OA procedures if you have a OLE/COM interface.

  http://msdn.microsoft.com/en-us/library/aa238863%28v=sql.80%29.aspx