[thelist] (sql2k) syntax error in sproc

[Stevenson Ngila]

====//====

and when I Check Syntax, I get error 170:  incorrect syntax near ')'
====//====

Try
<><>><><><<><>><><><<><>><><><<><>><><><<><>><><><
IF EXISTS Begin
 SELECT * FROM sysobjects 
	   WHERE id = object_id(N'[dw_tab].[dbo].[@ArchiveTableName]') 
	   AND OBJECTPROPERTY(id, N'IsUserTable') = 1
end

<><>><><><<><>><><><<><>><><><<><>><><><<><>><><><