Re: Trigger and SP

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 12/15/04 

Date: Tue, 14 Dec 2004 19:59:53 -0500

I'm still very interested in how this is done and would appreciate a BOL
reference. 

-- 
   Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinnaclepublishing.com
.
"David Gugick" <davidg-nospam@imceda.com> wrote in message 
news:%23j2rSwj4EHA.1188@tk2msftngp13.phx.gbl...
Tom Moreau wrote:
> Really?  Can you point me to the ref in the BOL?  Thanx.
>
Tom, I think it was his grammar that threw you off.
He said, "Actually, a trigger CAN have a parameter passed FROM it to a
stored procedure."
When it would have made it easier if it simply read, "Actually, a
trigger CAN pass a parameter to a stored procedure."
-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • Re: transaction isolation level
    ... The page in BOL for SET has this: ... "If a SET statement is set in a stored procedure, ... SQL Server MVP ... >I didn't think this was true for SET ISOLATION LEVEL. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... I'm afraid you cannot get it in SQL Server 2000 ... sp_trace_setevent stored procedure has a parameter EventId and there is a ... list of event numbers (See BOL) ...
    (microsoft.public.sqlserver.security)
  • Re: Batch File.
    ... You need to start SQL Server outside a stored procedure, for obvious reasons. ... David Gugick ...
    (microsoft.public.sqlserver.clients)
  • RE: using stored procedure in select statement
    ... You can not use stored procedure in any SELECT directly. ... Look in BOL. ... "Rizwan" wrote: ... > I am using MS SQL Server 2000. ...
    (microsoft.public.sqlserver.programming)
  • Re: Wartungsplan schlägt teilweise fehl
    ... aus BOL SIMPLE is the default setting for SQL Server Personal Edition ... Die master-DB hat immer simple. ... Sicherung der Datenbank und alle Sicherungen der Tranaktionslogs. ... Lesestoff dazu im "SQL Server 2000 Operations Guide": ...
    (microsoft.public.de.sqlserver)