Showing posts with label possble. Show all posts
Showing posts with label possble. Show all posts

Thursday, March 22, 2012

Calling one application from SQL Server

Is it possble to automatically call an application when another application makes an INSERT from inside sql server? If its possible - how do I do that?

Thx in advance

/MiZzaYou can get SQL to make COM style calls...look up extended procedures. However, you'd still need a way to identify what the calling application was.|||Main stored procedures to use:

sp_OACreate - Creates an instance of the OLE object on an instance of Microsoft® SQL Server?. (e.g. COM component)

sp_OAMethod
sp_OADestroy

Support stored procedures to use:

sp_OAGetErrorInfo
sp_OAGetProperty
sp_OASetProperty
sp_OAStop