title: Error creating a table : "There is already an object named ... in the database", but not object with that name
body: <p>I'm trying to create a table on a Microsoft SQL Server 2005 (Express).</p>
  
  <p>When i run this query</p>
  
  <pre><code>USE [QSWeb]
  GO
  
  /****** Object:  Table [dbo].[QSW_RFQ_Log]    Script Date: 03/26/2010 08:30:29 ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  SET ANSI_PADDING ON
  GO
  
  CREATE TABLE [dbo].[QSW_RFQ_Log](
      [RFQ_ID] [int] NOT NULL,
      [Action_Time] [datetime] NOT NULL,
      [Quote_ID] [int] NULL,
      [UserName] [nvarchar](256) NOT NULL,
      [Action] [int] NOT NULL,
      [Parameter] [int] NULL,
      [Note] [varchar](255) NULL,
   CONSTRAINT [QSW_RFQ_Log] PRIMARY KEY CLUSTERED 
  (
      [RFQ_ID] ASC,
      [Action_Time] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  </code></pre>
  
  <p>I got this error message</p>
  
  <blockquote>
    <p>Msg 2714, Level 16, State 4, Line 2
    There is already an object named
    'QSW_RFQ_Log' in the database. Msg
    1750, Level 16, State 0, Line 2 Could
    not create constraint. See previous
    errors.</p>
  </blockquote>
  
  <p>but if i try to find the object in question using this query:</p>
  
  <pre><code>SELECT *
  FROM QSWEB.sys.all_objects
  WHERE upper(name) like upper('QSW_RFQ_%') 
  </code></pre>
  
  <p>I got this</p>
  
  <blockquote>
    <p>(0 row(s) affected)</p>
  </blockquote>
  
  <p>What is going on????</p>