Re: How to monitor Triggers in VB6

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 08:40:08 +0100

You can use Profiler to or SQL Trace to monitor what's currently executing
on the server. 

-- 
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"dudebig" <hhugg@hotmail.com.no-spa.m> wrote in message
news:Xns9520A57BBA56Ehhugghotmailcom@130.225.247.90...
> 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

  • Re: Stored procedure/trigger and scripts
    ... SQL Server has permissions to execute xp_cmdshell. ... Please read up on xp_cmdshell within Books Online (within the SQL Server program group). ... >> client to change their password they have to call the "Client Relations" ...
    (microsoft.public.sqlserver.programming)
  • Re: DTS package not executing from within a webservice
    ... method on the Server A which has a web method, Am trying to execute a DTS ... created a wrapper and using the methods of the DTS.dll ... Not associated with a trusted SQL ... Server connection. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Measuring the duration of encrypted stored procedure
    ... procedure is executed 4 times and the time differences are noted using SQL ... > I'm not aware of an reasons the encrypted proc should be any different. ... >> to execute than the unencrypted version!!! ... > time to run based on load on the server or the parameters you're passing ...
    (microsoft.public.sqlserver.server)
  • Re: Executing a SQL script on server
    ... > How can I using ADO send a SQL script to the server to be executed there? ... An example VBScript program to execute a stored procedure: ... ' Specify the SQL Server and Instance. ...
    (microsoft.public.vb.database.ado)
  • SQL Performance Object Counters not seen
    ... Performance Log group, with admin privileges on the SQL ... Server to monitor over Terminal Services. ...
    (microsoft.public.sqlserver.security)