what is extended StoreProcedure ?

Answer Posted / abdul raziq

An extended stored procedure is simply a procedure that is
implemented in a dynamic link library (DLL) — a library that
is called by an application at runtime. Extended stored
procedures can be used in much the same way as database
stored procedures, except that extended stored procedures
normally perform tasks related to the interaction of SQL
Server with its operating environment. Tasks that are either
too complicated or just not possible using Transact-SQL can
often be performed with extended stored procedures.

Extended stored procedures are written using the Open Data
Services (ODS) API. ODS is written and supported by
Microsoft and is available on the Workstation version of SQL
Server and as a separate product (and in the Back-Office
Development Kit). The ODS development package includes both
a static-link library (Opends60.lib) and C header files that
let you create fully functional database services. ODS
applications are dynamically linked with Opends60.dll.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use sql limitations? Which constraints can we use while making a database in sql?

559


What do you know about normalization and de- normalization?

468


What is the chart in report?

111


How to replace null values in expressions using isnull()?

646


What is the maximum rows in sql server table?

508






Determine how to use the inserted and deleted pseudo tables?

533


Explain database normalization?

645


Do you know what are different types of replication in sql server?

508


What is raid? : SQL Server Architecture

589


Working with TLogs

1447


What is sql language?

547


Is sql server implemented as a service or an application? : Sql server database administration

509


System requirements for sql server 2005 express edition?

569


What are the kinds of subquery?

528


What are different types of table joins?

557