New procedure is not displayed in SQLSERVER

-1

Follow the steps in doc in microsoft:

link

I changed the permissions but could not display "new procedure" when clicking the new procedure folder

    
asked by anonymous 28.06.2018 / 02:26

2 answers

1

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.

    
11.08.2018 / 01:24
0

Alternatively you can use create via code.

CREATE PROCEDURE NOME_DO_PROCEDIMENTO  
AS  
BEGIN  
-- CORPO DO PROCEDIMENTO 
END;
    
11.08.2018 / 01:18