Unanswered: sa login fails whne creating SP_procedure
We just had to rebuilt one of our servers. I am trying to recreate one of the stored procedures that used to run a job fine, it gives me back sa uer login failure. Any help would be greatly appreciated. I have chaecked the password for sa and it is what it used to be previously.