Tables

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  July 15, 2004 at 7:06 am

  #161887

  Hopefully this is a real easy question.

  I have a database where currently if I need to select against of the tables I have to also specify the db and the owner of the object (e.g. MyDB.dbo.MyTable).  If I just try to specify MyTable, I get an error.  Any ideas?

  Shane Stecher

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  July 15, 2004 at 7:25 am

  #514643

  If your username is not a Data Base Owner you will have to specify the dbo.table. (Unless you fiddle around with allias's)

  However you do not have to specify the Database, unless the table is in DB A and you have logged into DB B.

   

   

  
  Andy.