Most database development shops have database objects owned by database owners (dbo). Database developers will connect to a development database that has the connection mapped to a user in the database other than the dbo.
At times, developers may inadvertently create a database object without prefacing the object name with dbo. The result is that the database object will be owned by the database user, which the developer is using for the connection.
To help alleviate this problem, to assist developers, and to orient new database developers to this standard way of development, use SQL Mail to create daily reports for non-dbo-owned database objects.
It's beneficial to have all database developers belong to a domain global group for the following reasons:
- You can parse the domain global group and create NT authenticated logins for each developer on each SQL Server.
- You can map the NT authenticated logins to database users on each database.
- You can map the database users to e-mail names and send the non-dbo-owned database object report to the users that have mapped e-mail names.
Database administrators should belong to an e-mail distribution group that they can copy on the non-dbo-owned database object report. Database administrators can follow up with the database developer to change the database object owner to dbo.
It can be frustrating for database developers when there are two objects with the same name and different owners. While developing one day, the developer may not be using dbo to preface database object. However, the next day, the database developer may preface the database objects with dbo and have results that differ from the previous day. The database developer may lose productive hours debugging the differing results. A non-dbo-owned database object report would help alert database developers before they spend valuable development time debugging.
For More Information
- What do you think about this tip? E-mail the Editor at tdichiara@techtarget.com with your feedback.
- The Best SQL Server Web Links: tips, tutorials, scripts, and more.
- Have an SQL Server tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical SQL Server questions--or help out your peers by answering them--in our live discussion forums.
- Check out our Ask the Experts feature: Our SQL, Database Design, Oracle, SQL Server, DB2, metadata, and data warehousing gurus are waiting to answer your toughest questions.
