Using SQL Server 2000.
I have a new database, which has the exact same structure as an existing database. The data is different, but same Tables, View and Stored Procedures.
Anyway, I'l like to copy the security model from the existing into the new database- same roles, groups etc.
How would I do this?