title: Invalid object name (table not found on renaming)
body: <p>I have renamed a table using </p>
  
  <p>Exec sp_rename 'table1','dbo.table_new'</p>
  
  <p>the table got renamed but when i do select * from dbo.table_new, its saying Invalid object name </p>
  
  <p>but when i do select name,* from sysobjects where name like '%dbo.table_new%' i can see the object exists.</p>
  
  <p>How do i view the table now ?Do i need some right ?</p>