• Nisha - you can use enterprise manager and the scripting wizard to script the text either into individual files or all stored procedures in one big file and then print them out!

    if you right click on the database - go to "all tasks" - generate sql scripts - you can then enter your specs in each tab...under the options tab you can check either the "create one file" or "create one file per object"!

    hth!







    **ASCII stupid question, get a stupid ANSI !!!**