Using xp_hello

Extended Stored Procedure Programming

Extended Stored Procedure Programming

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