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

What are the new scripting capabilities of ssms? : sql server management studio

1116


What is sql azure database?

206


What are sub reports?

208


What is inline variable assignment?

1079


explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1151


Difference between 2NF &3NF ?

1130


How to join two tables in a single query in ms sql server?

1056


how many layers of tcp/ip protocol combined of? : Sql server database administration

1048


Explain what is the use of custom fields in report?

957


What is data modeling and Reterminal integrity?

2006


How to write a query with a right outer join in ms sql server?

960


What are the steps to take to improve performance of a poor performing query? : sql server database administration

1089


Explain hostprotectionattribute in sql server 2005?

1070


What is the recovery model? List the types of recovery model available in sql server?

944


Do you know what is difference between index seek vs. Index scan?

997