• I agree with Andy overall. In ten years of working with SQL Server, ownership chains cause many more problems than they solve.

    The only place where I have seen them useful is in allowing developers to create their own tables for testing. Since they are owned by the individual person, they are only for that developer to test. When the item progresses beyond the unit test stage, then they submit the table to the DBA, who changes the owner or recompiles.

    Steve Jones

    steve@dkranch.net