Thanks AJ Ahrens...My problem is fixed.

Could you show me an example with the query below?

SELECT COUNT(*) FROM PS_ACTN_REASON_TBL

Thanks for the reply. I have SET NOCOUNT ON in my script. The command only turns the (1 row(s) affected) on/off. Is there another command that you would know that...