Re: Extended SP

From: SriSamp (ssampath_at_sct.co.in)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 10:59:45 +0530

At the most basic level, a normal stored procedure is created using T-SQL.
An extended stored procedure is created using C/C++ and then registered with
SQL Server. 

-- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Ramesh" <ramesh@mail.punecity.com> wrote in message
news:eGTmKhtFEHA.740@tk2msftngp13.phx.gbl...
> Hii
> Can anyone tell me the difference  between  normal stored procedures and
> extended stored procedures?
> TIA
> Ramesh :)
>
>

Relevant Pages

  • Re: xplog70.dll
    ... What extended stored procedure are you calling from ... >I have a job that executes a DTS-package which in turn call a store procedure ...
    (microsoft.public.sqlserver.security)
  • Re: Logging within User_Defined Functions (UDF)
    ... Despite its name, xp_execresultset is an ordinary stored procedure, not an extended stored procedure. ... Ultimately you can only execute ... > DECLARE @cmdstr nvarchar ...
    (microsoft.public.sqlserver.programming)
  • Re: Sql Server Trigger that calls Win32.SetEvent
    ... actions outside of SQL Server (or external information) can be ... triggered and returned to SQL Server with an extended stored procedure. ...
    (microsoft.public.sqlserver.server)
  • Re: Rename xp_cmdshell
    ... The person who advised this is completely wrong, you can not rename an ... extended stored procedure, because the name of an extended stored procedure ... is the physical entrypoint of the function inside the DLL. ...
    (microsoft.public.sqlserver.security)
  • extended stored procedure catch 22
    ... How does a stored procedure call an extended stored procedure, ... (I dont want to give direct permission ... It seems you have to turn on database chaining, ...
    (microsoft.public.sqlserver.security)