How to monitor Triggers in VB6

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: dudebig (hhugg_at_hotmail.com.no-spa.m)
Date: 07/08/04 

Date: 08 Jul 2004 20:14:14 GMT

I have this triggers in T-SQL to execute when a product qty is 0, it does
work, but I have to be able to monitor this on a remote PC using VB6.

I know how to execute storeproc with VB6, but this is something I cannot
figure it out yet.

I have this same problem when trying to get an Activity Report from SQL
Server for a particular Table. How can I know who is accesing the Table? I
try the triggers for update/insert/delete and refreshing the recordset but
its not practical, I have a timestamp and terminalID fields con the table I
want to monitor.

Remote users are using a common password for the connection, and the
authentification is based on Host_ID() and a User table with login and
password.

Relevant Pages

  • How to check for SQL triggers in VB6
    ... I have this triggers in T-SQL to execute when a product qty is 0, ... but I have to be able to monitor this on a remote PC using VB6. ... Remote users are using a common password for the connection, ...
    (microsoft.public.vb.database.ado)
  • Re: WScript.Shell.Exec().StdOut.AtEndOfStream waits for text - solution - ExecWithTimeout.ws
    ... Execute the monitor. ... Read output from the app. ... Read output from the monitor. ... execute a Windows command, copying stdout and stderr. ...
    (microsoft.public.scripting.jscript)
  • Re: SSMS Pain in the butt
    ... execute and slide the execution window over to monitor 2 and run my stored ... I come home, open SSMS, right click on my stored proc and select execute and ... open the stored proc in execution mode and drag the window back to ...
    (microsoft.public.sqlserver.tools)
  • Re: How to monitor Triggers in VB6
    ... You can use Profiler to or SQL Trace to monitor what's currently executing ... Vyas, MVP (SQL Server) ... > I have this triggers in T-SQL to execute when a product qty is 0, ...
    (microsoft.public.sqlserver.programming)
  • Re: SSMS Pain in the butt
    ... execute and slide the execution window over to monitor 2 and run my ... I come home, open SSMS, right click on my stored proc and select execute ... solution, other then drive to work, is to connect another monitor to y ...
    (microsoft.public.sqlserver.tools)