Or rather, on a Test or Development server instance. If you need to do this to a Live server, then you have larger issues. Most sites have servers for Developers and DBAs to work their dark magic, as well as various test servers for the next level of testing. These servers do, of course, have …
Notes on SQL 