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

How do I run a trace in sql server?

928

---

What is the temp table?

865

---

What are indexers?

1034

---

What is the difference between SQL notification and SQL invalidation?

1072

---

Explain temporary table vs table variable by using cursor alternative?

942

---

What is a matrix in ssrs?

135

---

How to create an multi-statement table-valued function?

938

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1206

---

Explain for xml explicit mode?

912

---

What is a cursor, index in sql?

1012

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

932

---

What are the types of joins in sql?

1055

---

What is use of except clause?

1036

---

What is an indexing strategy?

942

---

Explain “not null constraint” in sql server?

955

---