Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain how to send email from sql database?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Why should we go for stored procedures? Why not direct queries?
How can you check the level of fragmentation on a table?
How to run sql server 2005 books online on your local system?
How do you implement session management in SQL Server mode?
What is msdb database? : SQL Server Architecture
What will be the maximum number of index per table?
What is the difference between a clustered index and a non-clustered index?
What are the essential components of sql server service broker?
Explain rdbms?
Define clusters?
What are the advantages of log shipping?
Name three of the features managed by the surface area configuration tool? : sql server security
What is data source object?
