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
Explain foreign key in sql server?
State the difference between local and global temporary tables?
What is a transactions?
How do I start sql server?
What do you understand by integration services in sql server?
What is the sql case statement used for? Explain with an example?
Can you type more than one query in the query editor screen at the same time?
what's the difference between a primary key and a unique key? : Sql server database administration
optimization techinques
What does the automatic recovery do?
What is b tree index?
Why we use functions in sql server?
What are the benefits of filtered indexes?
How to view the error log for any specific instance? : sql server database administration
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
