I am using the SQL Server 2008 R2 Developer Edition, Here I want to generate the scripts for Stored Procedures, Views,Functions etc. When I tried last few days it worked fine but now it is not working. I have right clicked the Database and selected Tasks-->Generate Scripts--> Select Specific files---> Selected the Stored Procedure check box. Its Executing more than 3 hrs but the script is not yet generated and there is no error message. After that I have selected only 25 Stored Procedures at that time also I am facing the same Problem. Can you Please help me to sort out this issue.
Thanks in Advance