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 essential components of sql server service broker?
What happens if null values are involved in boolean operations?
What is sql server query analyzer?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What samples and sample databases are provided by microsoft?
What is a collation?
what's new in sql server 2016?
How can change procedure in sql server?
How many non clustered indexes there can be on table ?
Explain tables in SQL Azure?
Are connections to sql server encrypted?
What is sql azure database?
Why do we use trigger?
Can we call stored procedure in view in sql server?
What is resource governor in sql server?