Dear Nojetlag,
I've tried to reproduce the problem using the files you've sent to GertD, and was not able to do that. The identity was reset on every successful deployment.
HOWEVER, when target database is in use (i.e. you have an open SSMS query windows against it, etc) Deployment fails (there is a message about it), because TargetDB cannot be dropped. In this case, for obvious reasons, identity is not reset.
I may be missing some steps in the process, so if you are still having the problem, can you, please send me the detailed steps to reproduce the problem (i.e. Open the project, Click Deploy, etc).
Thank you for your help,
|