To use the sample extended stored procedures, a SQL Server system administrator must make the procedures in XP.DLL available as SQL Server extended stored procedures, either by using the methods described in Adding Extended Stored Procedures to SQL Serveror by running the XP.DLL installation script, INSTXP.SQL, that is provided with SQL Server. The INSTXP.SQL script registers each of the XP.DLL procedures as SQL Server extended stored procedures and gives all users EXECUTE permission to the procedures.
To run the XP.DLL extended stored procedures, you can log in to SQL Server and issue the EXECUTE statement, specifying the name of the extended stored procedure to use and any valid arguments defined by that procedure (described in the following sections).
Like standard stored procedures, extended stored procedures support return status values and support the use of input and output parameters. Parameters are used in some of the following examples. For information about passing parameters in a stored procedure, see the Microsoft SQL Server Transact-SQL Reference.