Attached DB and no user tables showing up.

• lg

  SSC Veteran

  Points: 266

  More actions

  April 23, 2004 at 2:18 pm

  #85059

  Anyone ever encountered this problem before or have any suggestions?

  Let me know also if you need more information.

   

  Db has been attached to a different SQL Server than the one it originated on...possible a user/db ownership issue? I have no documentation on how this particular db was created.

   

  Thanks in advance.

  Louba

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  April 23, 2004 at 2:46 pm

  #504085

  I would try the refresh button first (just in case) if this fails I would research the sp_change_users_login and see if there are an "orphans".

  Are you the dbo of the database?  If not can you be added as such and see if they show?

  Can't wait to see the answer

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net