Unable to see user-owned objects in 2005

• sunshine-587009

  SSCrazy Eights

  Points: 8981

  More actions

  February 2, 2009 at 10:52 am

  #130264

  I am unable to see user-owned objects in SQL Server 2005 SSMS, but am able to see them in SQl Server 2000. Why is this, and how can I fix it so that I can see all objects. I am logged in as Sql server login SA. I can also see one user object by logging in as Windows authenticated with SA rights.

  ¤ §unshine ¤

• Jason Crider

  SSCertifiable

  Points: 6019

  More actions

  February 2, 2009 at 9:51 pm

  #936903

  At exactly what level are these user objects missing?

  Are you in remotely?

  Have you tried from both SSMS and EM on the SQL Server locally?

  MCITP, Database Administrator
  A hodgepodge of Information Technology and Life
  LinkedIn Profile
  My Twitter