Hi

I posted the query below in SQL Server section, but no one responded, hopefully someone here may help me out.

http://p2p.wrox.com/topic.asp?TOPIC_ID=51605

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

__________________
Regards
Mike

You can't do this through Query Analyzer (that i know of) you can, however, do it through enterprise manager.

Go into Enterprise manager and right click on the database that has the stored procedures you want to script, right click go to the 'All Tasks' menu and select generate SQL Script.

On the window that pops up, press the 'Show All' button and check the All Stored Procedures check box. Click ok and you have a script that will generate all of your stored procedures.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thanx parsons

Yup, I know the way to generate script via Enterprise Manager, was thinking that it could be possible via Query Analyzer. Anyways, thanx for the quick reponse.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.