在Visual Studio SQL Server 2008数据库项目中部署存储过程问题请帮助 [英] Deploying stored procedures in Visual Studio SQL Server 2008 Database Project problems PLEASE HELP

问题描述

我尝试使用Visual Studio 2010部署存储过程，就像我在2008年使用的那样。 问题是现在需要执行所有这些数据库更改才需要所有这些额外权限。 有没有办法不做所有这些事情。 
我想要做的就是部署一堆存储过程，而不需要2010年所需的所有增加的安全性。 我用来能够部署和构建错误。 它现在创建alter database statments。 如何在不弄乱数据库设置的情况下部署
sps？ 我可以关闭所有这些吗？

Im trying to deploy a stored procedure using Visual Studio 2010 like I use to with 2008.  The problem is that is trys to do all these database changes now that require all this extra permissions.  Is there a way to not do all these things.  All I would like to do is deploy a bunch of stored procedures without all this added security that 2010 requires.  I use to be able to deploy and build withouot error.  It creates alter database statments now.  How can I just deploy the sps without messing with the database settings?  Can I turn all that off?

推荐答案

在这里你必须检查SQLDeployment的属性，您可以通过右键单击DB项目并选择Properties选项以及Database.sqldeployment，Database.sqlpermissions和Database.sqlsettings来访问所有这些属性。

Here you have to check the properties of SQLDeployment, manifest file etc. All these properties you can access by right clicking the DB project and choose Properties option as well as from Database.sqldeployment, Database.sqlpermissions, and Database.sqlsettings.

您设置目标数据库具有的选项。

You set the options that your target database have.

这样，DBproject就不会生成你不喜欢的无关代码。

In that way the DBproject will not generate the extraneous code that you don't like.

谢谢，

Neeraj

这篇关于在Visual Studio SQL Server 2008数据库项目中部署存储过程问题请帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！