What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
- 3 Answers
- 11838 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / dharmendra k. dixit
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.
SOme are the type of Extend Stored Procedure..
XP_Cmdshell, xp_logevent, xp_deletemail, xp_sendmail
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How sql server executes a statement with nested subqueries?
How can we determine what objects a user-defined function depends upon?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is the difference between functions and scalar functions?
How exceptions can be handled in sql server programming?
Explain different backup plans?
How to list all objects in a given schema?
Explain the various types of concurrency problem?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is importing utility?
What is a transactions?
What are the differences between ms sql server & oracle?
What is a natural primary key?
what's the difference between delete table and truncate table commands? : Sql server database administration
How does the report manager work in SSRS?
