Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

what does it mean current user on the sp_disableTriggers?

3 posts in Trigger Last posting was on 2007-03-01 02:32:22.0Z
Sobari Tanuwijaya Posted on 2007-02-28 04:13:48.0Z
Date: Wed, 28 Feb 2007 11:13:48 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: what does it mean current user on the sp_disableTriggers?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.31.1
Message-ID: <45e500ce@solutions.advantagedatabase.com>
X-Trace: 27 Feb 2007 21:10:54 -0700, 125.163.31.1
Lines: 13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.31.1
Xref: solutions.advantagedatabase.com Advantage.Trigger:322
Article PK: 1136388

Guys,
as mention on the subject, does it mean current connection or user name?
why ask? because I made the application that connect to the database
using certain username for particular application, then if the current
user means current username it will affect all user who are using that
application.
What I want is disabling the trigger just for current connection.
Can this function help me do that? if so how?

Thanks in advance for your reply.


-- Tanu --


Peter Funk (ADS) Posted on 2007-02-28 15:21:40.0Z
Date: Wed, 28 Feb 2007 15:21:40 +0000 (UTC)
Message-ID: <864d0bcbaae28c929289b79a4dc@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: what does it mean current user on the sp_disableTriggers?
Newsgroups: Advantage.Trigger
References: <45e500ce@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.115
X-Trace: 28 Feb 2007 08:17:11 -0700, 10.24.38.115
Lines: 20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.115
Xref: solutions.advantagedatabase.com Advantage.Trigger:323
Article PK: 1136389

Hello Tanu,
Here's a note from the help file:

Disabling triggers for the current user only affects the connection on which
the disable request was processed. Different connections using the same user
name will not be affected.

So disabling triggers for the current user only affects the current user
connection. Other connections in that application or other instances of
that application on other PCs are not affected - even if they're using the
same user name. An example of how to disable triggers for the current user
would be:

EXECUTE PROCEDURE sp_DisableTriggers( NULL, NULL, FALSE, 0 )

Regards,
Peter Funk
Advantage R&D


Sobari Tanuwijaya Posted on 2007-03-01 02:32:22.0Z
Date: Thu, 01 Mar 2007 09:32:22 +0700
From: Sobari Tanuwijaya <tanuwijaya@gmail.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Re: what does it mean current user on the sp_disableTriggers?
References: <45e500ce@solutions.advantagedatabase.com> <864d0bcbaae28c929289b79a4dc@devzone.advantagedatabase.com>
In-Reply-To: <864d0bcbaae28c929289b79a4dc@devzone.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 125.163.4.29
Message-ID: <45e63a89@solutions.advantagedatabase.com>
X-Trace: 28 Feb 2007 19:29:29 -0700, 125.163.4.29
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!125.163.4.29
Xref: solutions.advantagedatabase.com Advantage.Trigger:324
Article PK: 1136390

Aah, thank you.
It seems this is the one I'm looking for.
Once again thanks.

-- Tanu --

Peter Funk (ADS) wrote:
> Hello Tanu,
> Here's a note from the help file:
>
> Disabling triggers for the current user only affects the connection on
> which the disable request was processed. Different connections using the
> same user name will not be affected.
>
> So disabling triggers for the current user only affects the current user
> connection. Other connections in that application or other instances of
> that application on other PCs are not affected - even if they're using
> the same user name. An example of how to disable triggers for the
> current user would be:
>
> EXECUTE PROCEDURE sp_DisableTriggers( NULL, NULL, FALSE, 0 )