David Fowler updates an older procedure:
Presenting you with an updated version of our sp_snapshot procedure, to easily create database snapshots.
This new version adds more flexibility to the procedure, allowing you to specify the snapshot’s suffix, add a timestamp and alter the path that the snapshot files are taken to.
Read on for the procedure text and an example of how to call it.