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 is hash nonclustered index
How to add code to the existing article (using improve article)?
What is set nocount on and what is set nocount off?
What are the advantages of passing name-value pairs as parameters?
What is store procedure? When do you use?
What are functions in the sql server?
What is coalesce in sql server?
How will you add a dimension to cube? : sql server analysis services, ssas
Tell me in brief how sql server enhances scalability of the database system?
Tell me can we use custom code in ssrs?
What is data source object?
What do you understand by hotfixes and patches in sql server?
How many types of cursor type are there?
How can we remove orphan records from a table?
What are the properties of the transactions?
