生成用于执行存储过程和视图的脚本不起作用 [英] Generating a script for taking Stored Procedures and View is not working

问题描述

我使用的是SQL Server 2008 R2开发版，我在这里想要为存储过程，视图，函数等生成脚本。当我尝试过去几天它工作正常但现在它无法正常工作。我右键单击了数据库并选择了任务 - >生成脚本 - >选择特定文件--->选中存储过程复选框。它的执行时间超过3小时，但脚本尚未生成，并且没有错误消息。之后我当时只选择了25个存储过程，我也遇到了同样的问题。你可以帮我解决这个问题。







先谢谢你

Hi,



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

推荐答案

重新启动SQL Server服务;）



启动，停止，暂停，恢复，重新启动数据库引擎，SQL Server代理或SQL Server Browser服务 [ ^ ]

启动，暂停和停止SQL Server [ ^ ]

重新启动SQL Server数据库服务和SQL Server代理服务 [ ^ ]



再试一次;）

Restart SQL Server services ;)

Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service[^]
Starting, Pausing, and Stopping SQL Server[^]
Restarting the SQL Server Database Service and SQL Server Agent Services[^]

And try again ;)

这篇关于生成用于执行存储过程和视图的脚本不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！