Good day,
Does any one know a fast way to script the sa account and all its permissions for all the various databases it is a member of? I would like to create a duplicate user account quickly and am trying to by pass the process of manually doing it.
ThanksEXECUTE sp_addsrvrolemember 'New_SA_Login', 'sysadmin'
I've moved your post to the Microsoft SQL forum.
-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment