Answer / swaroop

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.

They are only available in master DB.

What are alternate keys?

0 Answers  

---

What is excution Plan in sql server

1 Answers   CarrizalSoft Technologies, TCS,

---

Do you know query execution plan?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

---

What is difference between temp table and cte?

0 Answers  

---

How to store pdf file in sql server?

1 Answers   CarrizalSoft Technologies, College School Exams Tests, TATA,

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

What is a DBMS, query, SQL?

0 Answers   Maveric,

---

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---