The verbage that Microsoft uses here is unfortunate, but it is standard terminology. In this case, the schema is referring to a SQL Server 2005 security schema, not a database schema. Unless you have a need to use a specific security schema, don't specify the schema_name.
>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?
>
>Thank you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer