June 17, 2016 at 12:46 am
Hi All,
I have created a SQL server database project using VS 2015 and my objective was to drop all invalid/unused database objects from this project/database. I have also added this database project in source control to implement versioning. After doing all this I have below questions
1. I got error on create user scripts hence grant execute to such users scripts as well during building this project, so how to correct these issues?
2. When my other team members will start working on this project then how will they make sure their local database is in correct state?
3. What is database snapshot?
If someone know on any good documentation on this please let me know.
June 21, 2016 at 11:47 pm
"Try opening SQL IDE with administrator privilege and check whether the user has the permission to execute the script.
A database snapshot is a read-only static view of a database that can be used for reporting purposes. Multiple snapshots can exist on a source database.
"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply