none
After SQL 2012 database deployment via visual studio 2012 user rights on database is remove RRS feed

  • Question

  • When we deployment SQL 2012 database via visual studio 2012, user rights on database is removed or permission removed.


    ABDUL HAFEEZ MCSE MCITP

    Tuesday, November 18, 2014 4:54 AM

Answers

All replies

  • Are the permissions modeled in your project? If not, try setting the IgnorePermissions option when publishing.

    Lonny

    Thursday, November 27, 2014 6:11 AM
  • Answer

    In deployment option Uncheck "drop object in target but not in project"


    ABDUL HAFEEZ MCSE MCITP

    Thursday, November 27, 2014 6:52 AM