Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Deploy Visual Studio 2008 Database Project

7 views
Skip to first unread message

SergeR

unread,
Sep 3, 2009, 3:08:02 PM9/3/09
to
CONTEXT:
- Visual Studio 2008
- SQL Server 2005
- I have DBO privileges and not sysadmin.

I have created a new Database project and was able to deploy successfully to
2 different servers. I added a primary key and now when deployong I get the
message "Unable to modify the database settings for DB_CHAINING or
TRUSTWORTHY. You must be a SysAdmin in order to apply these settings."

The database properties are set to false in the project and on the SQL
Server. Also the "Always re-create database" setting is off.

I don't want to modify these settings and would like to remove them from the
deployment script so that I can be able to deploy my database objects.


SergeR

unread,
Sep 4, 2009, 4:06:01 PM9/4/09
to
Problem fixed...

To bypass this issue while waiting for an answer, I deployed the script
using the command line MSBUILD. After successfully deploying via the command
line, I was able to deploy again using the IDE.

0 new messages