• Might want to put this in a SQL Server 2000 forum, but here's a head start:

    http://www.codeproject.com/KB/database/xyprocedure.aspx