sunshine-587009
SSCrazy Eights
Points: 8981
More actions
August 26, 2008 at 7:53 am
#197570
Is there a script that extracts or scripts out not just the users, actually there are quite a few for that, but the actual database roles for each user to be moved from 2000 to 2005?
¤ §unshine ¤
Steve Jones - SSC Editor
SSC Guru
Points: 736478
August 26, 2008 at 8:07 am
#863145
You can right click the database in SQL 2000 and generate a script. There is a checkbox to include security.
August 26, 2008 at 8:12 am
#863148
I've never used it for security, thank you so much!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply