Restore SQL Security

From: Alma (adcc69@hotmail.com)
Date: 03/24/03


From: "Alma" <adcc69@hotmail.com>
Date: Mon, 24 Mar 2003 14:25:58 -0800


Does somebody know about a tool or a way to restore SQL
Security when restoring SQL 2000 databases? I've tried
creating security scripts for the server and also for each
database and then run those scripts on another server with
the same DB, but I always have to manually fix it because
passwords won't pass or some roles don't create, etc.