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: Problem with bulk load security.
    ... The only user that didn't have the bulkadmin roll was the ID that SQL ... Did you to EXECUTE AS USER or EXECUTE ... Links for SQL Server Books Online: ... DDL Triggers with Server Scope and logon triggers ...
    (microsoft.public.sqlserver.security)
  • 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)
  • 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)