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
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is indexing and its types?
Does partitioning help performance?
How to test values returned by a subquery with the in operator?
Explain try...catch with sql server?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to access the inserted record of an event?
What do you understand by mirroring and mention the advantages of the mirroring?
Explain cross join or cartesian product in sql?
Name three of the features managed by the surface area configuration tool? : sql server security
Do you know what is difference between index seek vs. Index scan?
Tell me what are cursors and when they are useful?
define and explain the differences between clustered and non-clustered indexes.
What is sql server management studio? : sql server management studio