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
What are different types of views?
Which language rdl files made of?
explain declarative management framework (dmf) in sql server 2008?
Difference between report and query parameter. Why do we need different type of parameter?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Which are the third-party tools used in sql server and why would you use them?
What do you understand by recursive stored procedure?
Explain the dirty pages?
What is snapshot parameter in ssrs?
What is data block and how to define data block size?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Differentiate between a local and a global temporary table?
What is database architecture? : SQL Server Architecture
What is field with example?
When would you prefer to have a minimum number of indexes?
