Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is an extended Stored Procedure?



What is an extended Stored Procedure?..

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.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

what is the query and condition to delete datas in sql server.

2 Answers  


What are three major types of constraints?

0 Answers  


How to verify the port number of the sql server?

0 Answers  


what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,


What is the difference between coalesce() & isnull()?

0 Answers  


What is scheduled job and how to create it?

0 Answers  


How to modify the underlying query of an existing view?

0 Answers  


what is nonclustered index

0 Answers  


hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  


What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  


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

0 Answers  


What is the library index called?

0 Answers  


Categories