Of course :o(
Thank you

>The CREATE PROCEDURE statement has to be in the separate batch.
>
>>In Query Analizer I am trying this:
>>

>>     IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'SpAldinDoors' AND type = 'P')
>>        BEGIN
>>   	   CREATE PROCEDURE SpAldinDoors
>>           AS
>>           DECLARE @myTable AS Char(250)
>>
>>           SELECT @myTable=table_name
>>                  FROM INFORMATION_SCHEMA.TABLES
>>                  WHERE table_type = 'BASE TABLE'  AND table_name = 'ALADINDOOR'
>>
>>           IF @myTable IS NULL
>>              CREATE TABLE AladinDoor (Kod Int, Name nvarchar(25), Vid smallint)
>>
>>           INSERT INTO AladinDoor
>>           SELECT (Router*1000+Reader_1), Description, 255 FROM Door WHERE (Door.Router*1000+Door.Reader_1) NOT IN (SELECT Kod FROM AladinDoor)
>>
>>           INSERT INTO AladinDoor
>>           SELECT (Router*1000+Reader_2), Description, 255 FROM Door WHERE (Door.Router*1000+Door.Reader_2) NOT IN (SELECT Kod FROM AladinDoor)
>>
>>           SELECT * FROM AladinDoor
>>           GO
>>        END
>>

>>
>>But the result is
>>Server: Msg 156, Level 15, State 1, Line 3
>>Incorrect syntax near the keyword 'PROCEDURE'.
>>Server: Msg 170, Level 15, State 1, Line 20
>>Line 20: Incorrect syntax near 'AladinDoor'.
>>Server: Msg 156, Level 15, State 1, Line 1
>>Incorrect syntax near the keyword 'END'.
>>
>>Why?
>>If I try:
>>IF EXISTS (SELECT name FROM sysobjects WHERE name = 'SpAldinDoors' AND type = 'P')
>> print 'aaaaaaaaaaa'
>>
>>the result is 'aaaaaaaa'
>>
>>IF NOT EXISTS (SELECT name FROM sysobjects WHERE name = 'SpAldinDoors' AND type = 'P')
>> print 'aaaaaaaaaaa'
>>
>>nothing happens as expected.
>>But I want to create procedure ONLY if it not exists, Don't want to drop it first. How to do that?
>>TIA