• Thanks for the comments. As far as DTS pacakges go, I haven't done enough work in a multi-DBA environment to come up with a good one. I have done the following:

    DBAxxxxx - DBA related jobs (backup, etc.) with the xxx being a description.

    ExtractXXXXX - Extraction procedures for

    processes that I use to move data out of the database and send it somewhere else.

    Generate XXXX - DTS packages that generate data that is sent to a person, like a report.

    That's about as far as I've gotten. I like Antares idea for DTS packages.

    as far as adherence. I've never had an issue with going to a manager and asking for adherence. Then I get them to lean on the others.

    Steve Jones

    steve@dkranch.net