How to add a new stored procedure?

[Sun_Force]

My first attempt for a stored procedure.
The context menu when I right click Stored Procedures doesn't contain New Stored Procedure.

Is it normal?
Is there any other way to add a new stored procedure?

This is the same for system databases as well as local databases.

SQL Server Express 2019
Sql Server Management Studio 8.1


Any kind of help is much appreciated.

 

[arnelgp]

you try it first, it will show you the new stored proc template.
is "master" your default db (you did not create any?).

there are many samples on the net.

 

[Sun_Force]

you try it first, it will show you the new stored proc template.
is "master" your default db (you did not create any?).

there are many samples on the net.

Thanks for your help.

Selecting the first item (Stored Procedure....) brings up a new query window with a template.
When I save and close it, it doesn't appear in the list in Object Explorer.

I refreshed, restarted the server, closed and opened management studio, but it doesn't appear there.
If I attempt to run the stored procedure, I receive an error that it can not be found.

master is not the only database. I have two other databases. But the stored procedure I'm adding, will be used to schedule a backup.
According to Microsoft Docs, it should be under master.

Schedule and automate backups of databases - SQL Server

This article describes how to use a Transact-SQL script and Windows Task Scheduler to automate backups of SQL Server Express databases on a scheduled basis.

docs.microsoft.com

 

[arnelgp]

did you Execute it?
if you did. refresh master db.
the expand it again.

you will see this:

 

[Sun_Force]

did you Execute it?
if you did. refresh master db.
the expand it again.

you will see this:View attachment 96399

As I explained even if I refresh , it doesn't show up.
It seems it's a popular case.
Google brings up so many result with the same problem.

Thank you.

 

[arnelgp]

it's a popular case

i only Execute it once and it showed when i refresh.
i am using management studion 18.1 not 8.1

 

[Minty]

That's because you are in the system master database, and probably don't have privileges for that?

Try it under the database you are connecting to. If that doesn't work it will probably be an access rights issue.

 

[Sun_Force]

i only Execute it once and it showed when i refresh.
i am using management studion 18.1 not 8.1

Sorry, I meant 18.1

I will check the rights as @Minty suggested.
Thanks for your help.