Making a Stored Procedure in MS-SQL 2000

Hi,

Sorry, this is a very easy question. I have to create a stored
procedure in a SQL SERVER Database.

I have read lots on MSDN about the syntax of this stored procedure :
ie.

CREATE PROCEDURE spGetContctDetails
AS
-- get everything out of contact table
SELECT * FROM tblContact

but I cannot find anywhere how to actually add this procedure, so that
it is accessable in my VB.NET program.

What I am asking is : what screen do I type this into? Is it Query
Analyzer, if so where?

Its got me oh so confused. When I've got time i'll read all about SQL
Server, but for this morning I need to know how to simply add that
Stored Procedure to my database.

Thanks LOADS for any help.Type the CREATE PROCEDURE code in Query Analyzer. You can then execute
the proc from VB using the ADO command.execute method for example.
--
David Portas
SQL Server MVP
--