2005 sql server returns 'Invalid character value for cast specification'

[chenggong]

Hi, my VC++ 6.0 application calls my check_user_sp stored procedure that calls the sys.sp_helpuser system stored procedure: ----- CREATE PROCEDURE check_user_sp @inp_user VARCHAR(20) AS EXEC sp_helpuser @inp_user ----- I have no problem running the application against database on the 2000 sql server(2000 - 8.00.760), but I get 'Invalid character value for cast specification' error with the same database on the 2005 sql server(2005 - 9.00.1399.06). the sp_helpuser is dated 1996/08/14 10:33 on both 2000 and 2005 server, and I don't get error when exec my get_user_sp in the 2005 sql server management studio. what is 2005 sql server doing to cause this? THANKING FOR YOUR HELP!

[Mukkie]

Hello! try checking database collation settings / server collation settings.

[chenggong]

thanks! I checked and they have the same collation seetings. I looked into the sp_helpuser code and then realized that the one in sql server 2005 returns 7 columns but the one in sql server 2000 returns 6. My application expects 6 columns and gets the error with sql server 2005.