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