December 12, 2011 at 4:58 am
Hi all
Something that is confusing is the transfer of logins. I understand Microsoft have provided the following KB http://support.microsoft.com/kb/918992. However although the logins will be transferred what about the server level permissions and roles.
Do Microsoft provide something to script these out, or do I need to write my own?
Thanks
December 12, 2011 at 6:13 am
Honestly, it makes sense that roles and server level permissions are not included in this script. The script is intended for transferring logins, and is mainly used when you transfer a database from one instance to another. It is quite commonly seen that application users are sysadmin members when they're having their own SQL Server, and I would definitely NOT allow them to be so when I move the database to a database hotel on a SQL Server cluster.
I've not seen any standard script from Microsoft on this, you you can script out the action from SQL Server Management Studio to retrieve the code for it, and it should be pretty fast and straightforward to create a script for it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply