Follow the steps in doc in microsoft:
I changed the permissions but could not display "new procedure" when clicking the new procedure folder
Follow the steps in doc in microsoft:
I changed the permissions but could not display "new procedure" when clicking the new procedure folder
Look man, when I had this problem, I had to get the password set for the administrator, at the time of installation, I believe that only with it will you be able to access the bank with all the privileges to create this, or access the security to give access to create this type of object to other users.
I use the user "SA", but access it with the password of the installation act.
Alternatively you can use create via code.
CREATE PROCEDURE NOME_DO_PROCEDIMENTO
AS
BEGIN
-- CORPO DO PROCEDIMENTO
END;