Re: Extended SP ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vinod Kumar (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 10:40:36 +0530

AFAIK, You cannot do this in SQL Server 2000.

Having said that, SQL Server 2005 has flexibility in writing extended stored
procedures in amanged code and even triggers can be written in .NET
languages. These triggers have access to the pseudo tables INSERTED and
DELETED. 

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Ashkan Daie" <adaie@nospam.org> wrote in message
news:eRhTl9VDFHA.4072@TK2MSFTNGP10.phx.gbl...
> I wish it could :). That is why I am pursuing the extended proc method.
>
> "JohnnyAppleseed" <someone@microsoft.com> wrote in message
> news:u%23JCU6VDFHA.960@TK2MSFTNGP09.phx.gbl...
> > Could the programming possibly be written using T-SQL? If so, then don't
> > even pursue the extended proc avenue any further.
> >
> > "Ashkan Daie" <adaie@nospam.org> wrote in message
> > news:%23ehdN4VDFHA.1836@tk2msftngp13.phx.gbl...
> >> Hi All,
> >>
> >> I want to call an extended proc from a trigger. Is there a way to
access
> > the
> >> "Inserted" and "Deleted" tables from the extended proc??
> >>
> >>
> >> Thanks,
> >> Ashkan
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: New to SQL server
    ... it is called triggers. ... ANYTHING THAT YOU CAN DO IN JET IS BABY TALK COMPARED TO WHAT WE CAN DO ... anything that you can do in JET that I can't do in SQL Server ... self-referencing FKs and inline constraints. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: 2010: Essential Diffs?
    ... the view in SQL server is the same thing as a saved select query in access. ... The reason why we don't call them views in Access is because saved queries can also be update queries, delete queries, append queries etc. So using the term "view" has nothing to do with the new JET table engine level triggers. ... Stored procedures don't necessarily mean that they can return tables as data. ... Keep in mind also that these triggers have to be able to run even if VBA or ms access is not installed on your computer. ...
    (comp.databases.ms-access)
  • Re: Encrypting SQL objects
    ... objects, i.e. Stored procs, Views, triggers. ... engine must be able to read the source code at run to be able to compile ... And if SQL Server has access to it, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Express versus Access (In the World Series of Love)
    ... As far as the triggers are concerned, the first case is something to avoid ... have their usefulness, for updateability, but Jet has already updateability ... OF triggers to achieve the same, say, over view, so, advantage to Jet. ... MS SQL Server may have a horse shoe maker right out of the box, ...
    (microsoft.public.access.modulesdaovba)
  • Re: need information for "Before Select" Trigger
    ... As i've added "Enforced Constraints" ... There are no BEFORE SELECT triggers. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)