SQL Server >> what do you do when logic just stops working
I have this stored procedure which was working fine yesterday but today no
matter what I do only returns -1. I even changed the procedure to select *
from some table and return 0 (I've tried 1 as well) but regardless of what
I do when I call ExecuteNonQuery I get back -1
Connection string is correct, names are correct everything should work but I
am at a total loss as to WTF is happening.
SQL Server >> what do you do when logic just stops working
>I have this stored procedure which was working fine yesterday but today no
>matter what I do only returns -1. I even changed the procedure to select *
>from some table and return 0 (I've tried 1 as well) but regardless of what
>I do when I call ExecuteNonQuery I get back -1
>
> Connection string is correct, names are correct everything should work but
> I am at a total loss as to WTF is happening.
>
> I'm lost.
>
>