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
SQL Server Architecture ?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
what information is maintained within the msdb database? : Sql server administration
Can you get second highest salary from the table?
How to update values in a table with update statements in ms sql server?
Does the order of columns in update statements matter?
What is the stuff?
What is log in sql server?
How to trouble shoot if unable to connect SQL Server
How to use column default values in insert statements in ms sql server?
What is a DBMS, query, SQL?
What is the difference between char, varchar and nvarchar?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are data resources?
What is public role in sql server?