• Lynn Pettis (9/19/2012)


    Also, don't name your procedures with "sp_" as you may run afoul of a Microsoft system stored procedure of the same name.

    Quite true! In fact, don't start ANY name with "sp_".

    Or "sys".

    You might also want to avoid table/view names starting with any of these:

    filestream

    MS

    queue

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.