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

No comments:

Post a Comment