>The book is incorrect. When you follow steps you outlined below, you get a T-SQL template to create a sproc. Keith explained in other thread how to replace template placeholders with values you want. After you do that, you'll have T-SQL script to create the sproc. The sproc itself is a part of the script. You can save script (SAVE) for future modifications. EXECUTE script to add sproc to the database.
>
Just to add to my previous message. You are saying "the book in incorrect", that maybe, books often make incorrect statements. But how did the author of the book create a picture of a window "Stored Procedure ... New"? So this windows has to be somewhere, right?
It was so simple in SQL 2000, everything was very intuitive and clear. I know you didn't create SQL 2005 <g>, I am just venting my frustration.
"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