ssurekha2000 (10/17/2012)
checked the sp with jst return stmtalso checked it with simple select stmt without parameters
checkedd connection string
but still when executed frm application gives the same error
Have you checked connection string? Looks like you are not connecting to the server/database where you have made and making changes as proc with only RETURN has no character "4" inside of its body 😉