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
- 12547 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
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is a collation in ms sql server?
Why union all is faster than union?
What are the acid properties?
Why can there be only one clustered index and not more than one?
What are the security related catalog views? : sql server security
What are the basic functions for master, msdb, model, tempdb databases?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to bind a view to the schema of the underlying tables?
What is a join in sql? What are the types of joins?
How to create a new table in a given schema?
What are types of storage modes? : sql server analysis services, ssas
What is store procedure?
How to change the password of a login name in ms sql server?
What is sql server replication? : sql server replication
