> All objects "should" be owned by dbo. That is a best > practice. If they are owned by other owners, it can > lead to bad things as well as confusing code.
I disagree with your assertion that using the dbo alias for ownership is a "best practice". There is nothing wrong with allowing specific logins to own objects, as long as you're aware that you're doing this. In fact, I'll go a step farther and say that if there's any best practice in this, it's to explicitly state table ownership in your queries. Of course, there are plenty of people who might disagree with me: http://www.sqlservercentral.com/columnists/awarren/worstpracticesobjectsnoto wnedbydbo.asp Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207069 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
