In my company, we have many users with different permissions.
Obviously, we do not want to sp_addalias all users to "dbo".
When developer A creates table tblA, other users must access the table
with syntax like "select * from developerA.tblA". We can end up with
many queries like "select * from developerB.tblB", "select * from
developerC.tblC", etc.
This sort of syntax is nightmare when there comes a need to change
codes querying tables.
We would like all different users (with appropriate permissions)to be
able to do "select * from tblA", regardless of who created the table.
Sent via Deja.com http://www.deja.com/
Before you buy.