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

  • GilaMonster (1/13/2014)


    The only time I'll use three-part naming is when I know that I need to be crossing databases. Otherwise 2-part naming's fine.

    I agree with you Gail. Sprocs that span multiple databases are always an issue if/when they get moved around and/or renamed. There is not much that can be done other than making sure there is sufficient documentation indicating those objects that reference across to other databases.

    There is no easy around that one.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman