hi,

i was trying out the use of T-SQL Debugger to debug my stored procedures but when i ran the stored proc through "Run Stored Procedure" pop up menu i saw in the Output Window that the variable that i had configured to be of the type bit in the backend (bool in .NET) was displayed as -1 instead of 1. Have i done something wrong or it is a Debugger Faux Pas? If so has this problem been fixed and is the service pack available?

It would be right to mention that i used a dataset and command object to check the value of the return values and the field evaluated to True (1). So why does the Database Output window display -1?

please help if you can?

Regds,

SPK