Creating Stored Procedure in SQLServer2005

I have been using SQL Server 2000 and creating Stored Procedure. I need these Stored Procedure to create Reports in Crystal Reports.

In SQL Server 2000: it is very simple to create a stored procedure: Go to Enterprise Manager->Databases-> Choose a database-> stored procedure->New-> Simply Add to the following syntax:

CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS

GO

My problem is that it is More Complex to use Stored Procedure In SQL Server 2005:

the stored procedure is under Databases->choose a database->programmability->create new stored procedure: But how can I use it: I need your help

It is more complex than the Stored Procedure in SQL Server 2000

Thank you

Your help is highly appreciated

You can create the SP in Query Analyzer i.e. Sql Server Management Stodio.

In the query window select the database and execute the Sql code 'Create Procedure ...'

Senthil

I think that this will be a matter of becoming more familiar with the interface. If you are well aquainted with creating stored procedures in SQL 2000 then you will adjust to the 2005 interface rather quickly.

Are you perhaps being confused by the template that you can get when you create a new procedure

Can you provide me with more details

As how to reach the Stored Procedure and how to Execute it

Thank you

Are you getting the point to where you see something like this:

Thank you all,

I have found the Answer

I wasnt understanding the complex syntax

so i simply deleted it all and kept the Following

CREATE PROCEDURE [dbo].[NCompOpp] AS BEGIN

Select from opmgr where opmgr.rectype="OP"

END

my major problem is that there are slight difference between writing Stored Procedures in SQL Server 2000 and in SQL Server 2005