I'm just wondering if there is any way to take a backup of the full database without the security portion(users and permission). I'll be restoring this backup to another database but I dont want to over-write the users and its permissions in the new database.
Maybe you should consider SSIS to copy data between databases. You can transfer other objects also if, for example, you want to transfer stored procedures.
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply