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
Do you know sql server 2008 backup compression?
What is the difference between nvl and nvl2?
What is bit data type? What's the information that can be stored inside a bit column?
What is tablix?
What is a print index?
What is a synonym for manipulation?
What are the types of subquery?
What is model database in sql server?
Define candidate key, alternate key, and composite key.
What is transact-sql language?
How to concatenate two binary strings together?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Explain sql delete command?
How do you test your database? : sql server database administration
System variable and temporary variables