In SQL 2000 you could multi select many objects (for example 10 procs), right click and select 'All Tasks'>'Generate Scripts'. From here you could script an object w/both the drop, create and permissions. If it was a table you could do all of the above as well as indexes, keys, triggers, etc. It looks like the ability to do this type of activity was removed from SQL 2005. Does anyone know of a way to do this from SQL 2005?