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

1. Build and compile the Xp_hello.dll.
   
   
2. Place the compiled Xp_hello.dll in the Microsoft SQL Server\80\Tools\Binn directory.
   
   
3. Start the server.
   
   
4. Start SQL Query Analyzer, and then run the Xp_hello.sql script.

See Also

Extended Stored Procedure Sample: xp_hello

Samples