We have all our companies and data in 1 database.
In the database everything related to CompanyID = 1 is the Demo Company that the salesmen uses to demonstrate the system .
Problem is the salesmen tend to add/update/delete data during the Demo.
Using SQL Server 2014 Standard Edition, Is there a cool way to some how snapshot the data in the data just related to CompanyID = 1?
So when the next salesmen wants to a demo they can just "reset" everything back to the way it was for the next salesman?
Instead of writing a massive stored procedure to manually add/update/delete data back to the way it was pre-demo?