Re: Sql Server Trigger that calls Win32.SetEvent
From: Billy Yao [MSFT] (v-binyao_at_online.microsoft.com)
Date: 04/19/04
- Next message: Paul Ibison: "Execute SQL Statment"
- Previous message: Jacco Schalkwijk: "Re: Execute SQL Statment"
- Next in thread: Bill Sonia: "Re: Sql Server Trigger that calls Win32.SetEvent"
- Maybe reply: Bill Sonia: "Re: Sql Server Trigger that calls Win32.SetEvent"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Apr 2004 14:10:10 GMT
Hi Bill,
>From your description, I noticed that you'd like to call the event (Win32.SetEvent) from within a SQL Server
Stored Procedure. Based on my experience, actions outside of SQL Server (or external information) can be
triggered and returned to SQL Server with an extended stored procedure. With extended stored procedure
(s), we can dynamically load and execute a function within a DLL file.
See the following Knowledge Base (KB) article for more information:
190987 HOW TO: Use Extended Stored Procedures
http://support.microsoft.com/?id=190987
On the other hand, we can also use DLL-Based COM Object to throw the event from within a SQL Server
stored procedure. In this way, you are allowed to load and run custom Component Object Model (COM)
objects through a set of OLE Automation stored procedures or through extended stored procedures.
198891 INF: Enabling DLL-Based COM Object Execution Outside SQL Server
http://support.microsoft.com/?id=198891
Does this answer your question Bill? Please apply my suggestions and let me know if this helps resolve
your problem. If there is anything more I can do to assist you, please feel free to post it in the group.
Regards,
Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
- Next message: Paul Ibison: "Execute SQL Statment"
- Previous message: Jacco Schalkwijk: "Re: Execute SQL Statment"
- Next in thread: Bill Sonia: "Re: Sql Server Trigger that calls Win32.SetEvent"
- Maybe reply: Bill Sonia: "Re: Sql Server Trigger that calls Win32.SetEvent"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
