i'm wondering if there is any way to enforce object naming conventions (using three-part identifiers) within views/functions/procedures ?
for example, use
insert into myBase.dbo.myTable
insert into dbo.myTable
select * from myBase.dbo.myFunction()
select * from myBase..myFunction()
we have several sql2008 databases and several developers and although we have some (loose-ish) guidelines for naming conventions, they are not always adhered to.
i've read a little about policy-based management but i'm not clear if something like this can be achieved.
it seems to me the only way to ensure all developers adhere firmly to our naming conventions is to hold a staff meeting and drum it in to them!
perhaps someone could point me in the right direction ?