Executing the PROCSRV Procedures

This section contains examples of running each of the procedures that the PROCSRV sample application provides. To use these procedures, log in to SQL Server as a client and issue the EXECUTE statement, specifying PROCSRV as the remote server name, and specifying any valid arguments that are defined by the procedures.

Like standard stored procedures, the PROCSRV procedures support return status values and support the use of input and output parameters. Parameters are used in some of the examples.

For more information about using EXECUTE to invoke remote stored procedures and for information about passing parameters in stored procedures, see the Microsoft SQL Server Transact-SQL Reference.

Now see the following:

Using proclist to Display Help Information

Using sp_exec to Access External Processes

Using diskfree to Retrieve a Data Value from the External Environment

Using disklist to Retrieve a Results Set from the External Environment

Using scan_xbase to Access a dBASE-format file