Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ASP_DRUG_DEALER
Yak Posting Veteran
61 Posts |
 Posted - 2005-02-17 : 09:27:14
|
| Need a little help with this one. I am looking to copy some roles I created on my test machine. I can create the role using EPM, but having to copy all permissions from one db to another would be a pain.Any help would be great!Thanks,Doug |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-17 : 10:25:36
|
| Use EM to generate the sql script. Highlight the DBAction | All Tasks | Generate Sql ScriptOptions tab, just select "script database users and database roles"Be One with the OptimizerTG |
 |
|
|
|
|
|
Copy role from db to db?