• Good point Kevin.

    I have attached two screen shots that show how to get the Save Options that the OP had in SQL2000.

    This is how you select the Script to New Query Windo for the procedure:

    And this is the Save Dialog that you should see, with the Save Options:

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]