开发者

Arvixe Hosting and Visual Studio SQL Server Database Projects

开发者 https://www.devze.com 2023-04-01 14:24 出处:网络
I am using Arvixe to host my sql server and websites, and would like to begin managing my database with a Visual Studio SQL Server database project so that I can get some source control going on the b

I am using Arvixe to host my sql server and websites, and would like to begin managing my database with a Visual Studio SQL Server database project so that I can get some source control going on the backend.

When I try to script my database's CREATE TO statement or use Visual Studio's import wizard, I get a permissions error:

Requires VIEW DEFINITION, ALTER ANY LOGIN, and SELECT ON sys.sql_expression_dependencies or be a member of db_owner role.

Has anyone had any luck managing an Arvixe sql server database with Visual Studio Database Projects, or have any tips for using the tools without 开发者_运维技巧those permissions? Their Tech support has been unable to help so far.

Edit: I am a member of db_owner, but i think Arvixe restricts permissions since its a shared server instance.


you don't have enough permission on database. you must to have db_owner permission.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号