use quotes in table name INNER JOIN acmeschema."FooTable" solution SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO