|
Home > Archive > MS SQL Server > November 2005 > Extended Stored Procedures
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Extended Stored Procedures
|
|
|
| The database I am setting up requires a dll file to be added to extended
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
Diane
| |
| Dan Guzman 2005-11-08, 9:23 am |
| You can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8- 628108DDFF0B@microso
ft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
>
> Where/how is this done?
>
> Thank you.
>
> Regards,
> Diane
| |
| David Gugick 2005-11-08, 9:23 am |
| Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
>
> Where/how is this done?
>
> Thank you.
>
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
|
|
|
|
|