How to create a Store_procedure On the Server From SSMS

[syedshaffee]

Hi People,

How to create a Store_procedure On the Server From SSMS

Please Give me The Syntax of it

[Rabbit]

The basic syntax is

CREATE PROCEDURE ProcedureName
	-- Add the parameters for the stored procedure here
AS
BEGIN
    -- Insert statements for procedure here
END

[syedshaffee]

Thanx Rabbit i tried that But the Procedure is not saved when Checked Under "Programmabilit y" Please Help and when i clicked on save it is Shows to save it on my Local machine. i want it to be saved on the server. Please be gentle in am new in this "Creating Store Procedure"

[Rabbit]

If there are no error messages and it says it ran correctly, then it got created somewhere. Make sure you're in the correct database. And after you run a create, it doesn't automatically refresh the list of stored procedures, you have to manually refresh it by right clicking the stored procedure folder and clicking refresh. It may also be the case that you don't have the permissions to view the stored procedures, in which case you will have to talk to the database admin.

When you click save, that's just save the code, it's a text file basically. That doesn't create a stored procedure.

[syedshaffee]

Thanx a Lot rabbit for your reply

[PsychoCoder]

Another option is to right-click on Stored Procedures and select to add a new stored procedure like in the attached image:

[IMGnothumb]http://psychocoder.net/new_sproc.png[/IMGnothumb]

[zmbd]

PsychoCoder
Please take a look at your profile, profile settings, attachments and double check the path to the file you uploaded... I can't seem to get at it to fix your post.