Home Forums SQL Server 2012 SQL 2012 - General Is there a way of copying the securables definitions from 1 db to another? RE: Is there a way of copying the securables definitions from 1 db to another?

  • Rod,

    you can one of two things here.

    a) create the current users under security and once you restore they will sync up.

    b) new site new names, no worries, restore the database, delete the old users from the database then add the new user names in security.

    pretty simple

    MCSE SQL Server 2012\2014\2016