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

What is a cube? : sql server analysis services, ssas

957

---

Explain primary key in sql server?

984

---

What is BLOCK statements in SQL?

1219

---

SQL Server Architecture ?

2411

---

What are the different types of triggers in SQL SERVER?

1067

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1466

---

What is set nocount on?

902

---

Why do we use trigger?

927

---

What is field in algebra?

991

---

What is equi join with example?

1033

---

Define Unique Key?

957

---

Give main differences between "Truncate" and "Delete".

1045

---

Why union all is faster than union?

873

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

924

---

Can we install sql server 2016 on windows 7?

1087

---