• Sorry, but this part...

    One last note, if you want to create an SP and have it distributed (automatically included) with all databases you create then you will want to create the SP for the 'master' database. Also, this only gets used with newly created databases from the point after you created the SP...So, if you already have existing databases you will still have to create the SP for each one of them.

    ...doesn't make sense.

    It would make sense if instead of master you would write model.

    Nice article and I am currently testing things...:w00t: