Home Forums SQL Server 2008 SQL Server 2008 - General how to differentiate between two tables sharing the same name but belonging to different databases RE: how to differentiate between two tables sharing the same name but belonging to different databases

  • You can set a default database in user login level .Run below system proc to set your default database .

    Exec sp_defaultdb @loginame='ur Login', @defdb='sims'

    This sets by default database as sims when 'ur Login' login to ssms . Then you don't need to change database from the context box.

    I am not sure this is the right solution you are looking for.