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
What are the new scripting capabilities of ssms? : sql server management studio
What is sql azure database?
What are sub reports?
What is inline variable assignment?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Difference between 2NF &3NF ?
How to join two tables in a single query in ms sql server?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Explain what is the use of custom fields in report?
What is data modeling and Reterminal integrity?
How to write a query with a right outer join in ms sql server?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Explain hostprotectionattribute in sql server 2005?
What is the recovery model? List the types of recovery model available in sql server?
Do you know what is difference between index seek vs. Index scan?