We have a SQL Server Database in our local shop. There are 5 Databases in this SQL Server Instance. 3 were designed and built here for our use. The other 2 are commercial Databases bought by our Corporate Headquarters. The Production Databases are housed at corporate. We have a copy here for reporting purposes. The copy is backed up once a week to a portable Hard Drive transported to our office and restored to our Server. The problem is that Every week the permissions for those 2 databases are blasted and have to be recreated every week. Doesn't take that long but I was wondering if this was something we could create in a stored Procedure in the Master database and then run after the backup is restored. If so, where can I find the syntax for this in SQL Server books online? I've looked and either it's not in there or I'm not looking in the right place.
Thanks for any help you can give.