且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从Visual Studio调试SQL Server 2005中的存储过程?

更新时间:2022-05-28 21:50:27

此处的一个重要问题是,如果SQL Server进程作为本地系统运行,则此方法将不起作用,这是默认安装。以本地计算机管理员组中的帐户运行。

One important issue here is that this won't work if SQL Server process is running as local system, which is the default install. It needs to be running as an account which is in the administrator group on the local machine.

我要做的是在名为 sqlserver的框中设置本地用户,并将其放入本地管理员组。然后,进入服务控制面板,停止sql server服务。对其进行修改并将其设置为以指定的用户帐户而不是本地系统运行。指定sqlserver本地用户帐户和您创建的密码。然后重新启动服务。

What I have done is set up local user on my box named "sqlserver" and put it into the local administrators group. Then, go into the service control panel, stop the sql server service. Modify it and set it to run as the specified user account rather than as local system. Specify the sqlserver local user account and the password you created. Then restart the service.