Using xp_hello
This Microsoft® Visual C++® sample shows a basic extended stored procedure that accepts one output parameter and prints one result set.
Default Location
x:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\ODS\Xp_hello
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 and compile the Xp_hello.dll.
- Place the compiled Xp_hello.dll in the Microsoft SQL Server\80\Tools\Binn directory.
- Start the server.
- Start SQL Query Analyzer, and then run the Xp_hello.sql script.