If you ran the BackOffice Resource Kit CD-ROM Setup, you can access Sptstxt.sql from the Bork\Sql\Sprocs directory on your computer. Otherwise, install it from the BackOffice Resource Kit CD-ROM.
To install sp_help_sourcetext
Get the Sptstxt.sql script from the Sql\Sprocs directory on the BackOffice Resource Kit CD-ROM.
sp_help_sourcetext is installed from the script Sphstxt.sql. At the command prompt, use the isql utility to run the Sphstxt.sql script. For example:
C:> ISQL /Usa /Ppassword /Sserver_name /ilocation\sphstxt.sql
where:
/Ppassword
Is the password for the SA login.
/Sserver_name
Is the name of the server on which SQL Server resides.
/ilocation
Is the full path to the Sphstxt.sql script.