Interested to Buy Any Domain ? << Click Here >> for more details...
What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
- 3 Answers
- 12553 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar gupta
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 | 0 No |
Post New Answer View All Answers
What is a hint?
What is database dimension? : sql server analysis services, ssas
What do you mean by the term 'normalization'?
Explain a differential backup?
Do you know what are the properties of the relational tables?
What are the common performance issues in sql server?
What is implicit cursors?
Explain some stored procedure creating best practices or guidelines?
What is Command line parameters in PLSQL.?
What is a subquery in a select query statement in ms sql server?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Define the one-to-one relationship while designing tables.
Explain features and concepts of analysis services?
