I deployed my project to the target and after deployment it dropped my user. Understandable, I could no longer connect to that database. How do I prevent that I looked in the post deplyment scripts and found nothing specific to my user.

I do not have a server level role. Only dbo_owner for the target database.


Re: Visual Studio Team System - Database Professionals dropped user

Amos Soma

It probably dropped your user because it didn't exist in the source (project ) but did exist in the target (deployment database).