>The template of the store procedure has a term "schema_name". Would this be always the same as the name of the database? Is it a good practice to use a schema_name when creating stored procedures?
It's an evolution of the owner concept in SQL 2000. Leave it alone (dbo) for now.
--sb--