Answer / abdul raziq

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.

Answer / shantanub

An extended stored procedure is a function within a DLL
(written in a programming language like C, C++ using Open
Data Services (ODS) API) that can be called from T-SQL,
just the way we call normal stored procedures using the
EXEC statement. See books online to learn how to create
extended stored procedures and how to add them to SQL
Server.

Answer / naren

A DLL that contains extended stored procedure functions
acts as an extension to Microsoft SQL Server. To install
the DLL, copy the file to the directory containing the
standard SQL Server DLL files (C:\Program Files\Microsoft
SQL Server\Mssql\Binn by default).

To add each extended stored procedure function in an
extended stored procedure DLL, a SQL Server system
administrator must run the sp_addextendedproc system stored
procedure, specifying the name of the function and the name
of the DLL in which that function resides. For example,
this command registers the function xp_hello, located in
xp_hello.dll, as a SQL Server extended stored procedure:

sp_addextendedproc 'xp_hello', 'xp_hello.dll'

List out the differences between global and local temp tables in sql server?

0 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

What is table value parameters (tvp)?

0 Answers  

---

What is sql view?

0 Answers  

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

what do you understand by change data capture?

0 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

What is the definition for sql server 2000?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

What is sparse columns of sql server 2008?

0 Answers  

---