Hi fellow DBA's,
While I've been a DBA for a few years now, I'm rather green when it comes to SQL Server so please forgive the basic nature of this query.
Some developer types would like a database to be cloned, ie copied with all the objects, users, permissions, etc just without the data, so that only the bare bones/schema exists in the new one. Just wondering the best way of doing this?
I figured using DTS as it's worked good for the noddy N'wind DB, but is this the best way?
Thanks in advance,