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 extended StoreProcedure ?

Answer Posted / 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'

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know sql server 2008 backup compression?

971


What is the difference between nvl and nvl2?

981


What is bit data type? What's the information that can be stored inside a bit column?

924


What is tablix?

162


What is a print index?

886


What is a synonym for manipulation?

1002


What are the types of subquery?

1042


What is model database in sql server?

1056


Define candidate key, alternate key, and composite key.

924


What is transact-sql language?

1098


How to concatenate two binary strings together?

1130


What is scan table/view and seek table/view when its occurs? : sql server database administration

1055


Explain sql delete command?

1062


How do you test your database? : sql server database administration

1026


System variable and temporary variables

2255