What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
- 3 Answers
- 12735 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
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
List the ways in which dynamic sql can be executed?
Can you index views?
What is clustered index
How to convert character strings into numeric values?
Can sql servers link to other servers like oracle?
What is standby servers? Explain types of standby servers.
Why use identity in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is an indexed view?
How can I check that whether automatic statistic update is enabled or not?
How to provide default values to function parameters?
What kind of problems occurs if we do not implement proper locking strategy?
What are wait types?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
