>Dear all,
>
>I m a beginner in using Sql Sever2000, i have some doubts as a beginner,
> please, i need someones help to clarify my doubts.
>(1).In Sql Server, i found there are two types tools, one is Enterprise manager
>and otherone is Query analyzer i tryed both. but, i do'nt know
>which is the best to create and manage database,
>procedures etc.. can anybody tell me the purpose of
>each tools.

You can use which ever one you prefer.

Generally EM is used for doing DDL (Data Definition Langugage) where you perform the task visually and EM writes the DDL code and runs it for you.

Generally QA is used for doing DML (Data Manipulation Langugage) where you are writting SELECT, INSERT, UPDATE, DELETE queries. Also, this is the perfered tool for writting/debugging stored procedures and functions.

(2). In the stored Procedure section there is lot of pre-defined
>procedures and funtions. Can i delete it which are not using?

You can.

>if i delete it will effect anywhare in database or anywhare ?.

It depends on what they are. Some of the SQL tools create SP's for their own use, and you will find them recreated. I would just leave them alone.

>(3) i want to create a new procedure independendly, means like Procedures in VFP and after that i want to
> added into Procedure Section is it possible? Becasue i created a procedure using
>enterprises manager but i do'nt know where it stored.

All the SP's are stored in the system tables of your database. What EM is doing when you create an SP is using the

CREATE PROCEDURE key word. You can do this youself in QA also. The most popular way to do this is to maintain a text file off each SP. This text file will contain the CREATE PROCEDURE code and at the very top code to drop it. You can't create a procedure if it already exists. You can use EM to script all your SP's, choose one file per object.

Once you have all your SP's scripted you can open the file in QA, modify it and execute it. This will put your SP into the database.

HTH,
BOb