Home Forums SQL Server 2005 T-SQL (SS2K5) Best Practices/Standards - to include or not to include database owner for table names RE: Best Practices/Standards - to include or not to include database owner for table names

  • nataliehinnen (4/29/2009)


    Thanks for the replies so far.. I actually agree with including the db owner, but I work with a bunch of geeks who are afraid to "hard code" anything... so I need some ammo.

    If anyone else has an opinion, please vote.

    It's actually a good thing that they don't want to hard code anything. Wish I could find a group of developers like that. But back to the point. If they are putting the name of the procedure in the code then there's no difference to qualifying the name, as long as you won't have any regular users owning the same short-name procedure.

    For instance, if every user had to run a procedure called SetPassword, and all users owner their own, because it did something slightly different, then "hardcoding" "dbo." into the code would be a bad thing. If there is as much chance of the procedure owner name changing as there is of the actual procedure name changing, it's a no-brainer.

    Chris

    Learning something new on every visit to SSC. Hoping to pass it on to someone else.