Have to prefix table with schema in queries

• Ben-347858

  Old Hand

  Points: 391

  More actions

  July 12, 2006 at 11:45 am

  #153087

  We recently recovered from a catastrophic failure of our database server. After recovering and restoring my database when I run any queries either in Query Analyzer or in my web application I get an "Invalid Object name 'someTableName' " error. If I change my query to use [schema].[tablename] the query returns fine.

  Is there a way to fix this?

  Thanks,

  Ben

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  July 12, 2006 at 11:51 am

  #648772

  ALTER SCHEMA schema_name TRANSFER object_name

  see Alter Schema topic in BOL

  Regards,Yelena Varsha

• Ben-347858

  Old Hand

  Points: 391

  More actions

  July 13, 2006 at 5:28 am

  #648915

  Thank you very much Yelena. That was a big help to me.

  I'm still trying to understand the new security in 2005.