>>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.
Thank you. I have a book on SQL Server 2005, hopefully as I read it I will learn more about different concepts and terms used in SQL Server.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham