I have the following code in a sproc: IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dw_tab].[dbo].[@ArchiveTableName]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) and when I Check Syntax, I get error 170: incorrect syntax near ')' What am I doing wrong this time?