Using xp_srv_paraminfo_sample
This Microsoft® Visual C++® sample shows how to analyze parameters from an extended stored procedure call, and post a result set to the client about each parameter and parameter value.
Default Location
x:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\ODS\Xp_param
Running the Sample
To create the extended stored procedure DLLs for these samples, in the appropriate sample subdirectory, open the supplied .dsw file in Microsoft Visual C++.
To run this program
- Build the Xp_param.dll.
- Place the compiled Xp_param.dll in the Microsoft SQL Server\80\Tools\Binn directory.
- Start the server.
- Start SQL Query Analyzer, and then run the Xp_param.sql script.