In ISQL, type the following to find out what "length" the Login column is:
sp_help SubAccounts
Then go into the stored procedure and change the following line to reflect
that number:
DECLARE @username varchar(32), @acctid int
In other words if "sp_help subaccounts" returns a length of 16 for Login,
then change the above line to read:
DECLARE @username varchar(16), @acctid int
Or, if you're using SQL 7, you can change the length of the
SubAccounts.Login column to 32...
Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart