SQL SERVER 7.0

how can i EXEC stored procedure automatically?
i hav use trace flags 4022, which can do the task...
and create the stored procedure in the master dB,
but it still cant work, did i put the trace flags at the right place?
and how could the master dB trace which dB i use?
could anybody help me....

CREATE PROCEDURE [P11] AS
DBCC TRACEON (4022)
INSERT INTO TABLE1
{CODING...}

Hi, try:

CREATE PROCEDURE proc_name
@Field1 varchar(50),
@Field2 varchar(50)
As
INSERT INTO Table(Field1, Field2)
values(@Field1, @Field2)
Go

You can name 'proc_name' whatever you want the procedure to be called.

What do you mean by master DB? If you talking about the procedures, the system doesn't read from a mater database. When you make your SQL statement, you would use the database that you want to use (when you establish the connection).

To call the procedure you would execute:
proc_name Field1 Field2
(change as required)

As for DBCC TRACEON (4022), try executing it seperatly.

DBCC TRACEON (4022)
Go

DBCC TRACEON (4022) is basically used to ignore automatically started procedures.