Tag Archives: stored procedure

cannot find stored procedure SQL Server

I was creating a stored procedure on my live server and was constantly getting the error message “Cannot find stored procedure” no matter how many times i created the same stored procedure on the server. Worse if I would create … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

executenonquery returns -1 on success

ExecuteNonQuery is suppose to return the number of rows inserted, updated or deleted but in my case it always return -1 even though the record is successfully added. Found out SET NOCOUNT OFF was missing my in my stored procedure. … Continue reading

Posted in Tutorials/Tips | Tagged , , , , , | Leave a comment