Thanks for your reply.

This code was extracted from the procedure, and shows what is happening.

What worries me is if a execute the select count(*) outside the 'IF', is returns 0...

Thanks Joaquim. Actually I'm checking all stored procedures for this kind of problem (direct access to system tables, use of reserved words of SQL 2000, and maintenance operations, like management...