Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swaroop
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.
They are only available in master DB.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to get the definition of a user defined function back?
Explain optimistic and pessimistic concurrency?
What are the steps you will take to improve the performance of a poor performing query?
How to use values from other tables in update statements in ms sql server?
What is user-defined multi-statement table-valued function?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is an example of a foreign key?
explain different types of cursors? : Sql server database administration
What are sql dirty pages?
What are indexes in sql?
How to scale out a federation by Sql statement?
Can group functions be mixed with non-group selection fields in ms sql server?
What are the advantages of policy management?
What is sql server used for?
Tell me about joins in database system and explain each in detail.
