I am trying to call a stored procedure using arcpy.ArcSDESQLExecute to retrieve a single record. In MSSQL I can call the stored procedure and I get the expected value. When I use arcpy.ArcSDESQLExecute to execute the stored procedure I get a Boolean True value.
sdeConn.execute('EXEC dbo.usp_GetValue;') //Always returns true
Has anyone ever encountered this problem before.