December 25, 2012 at 11:28 pm
Hi Friends,
When am generating scripts of my database in sql 2008r2 am not getting the given permission of sql logins in the script. So kindly suggest how or what should I do to get the output.
Thanks in advance.
December 25, 2012 at 11:43 pm
see here http://weblogs.sqlteam.com/billg/archive/2010/07/08/Scripting-out-SQL-Server-Logins.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 26, 2012 at 10:49 pm
Guess you are using "Generate Script" in ssms.
Ensure you have selected "Script Logins" and "Script Object-level permission" to TRUE( they are in Advanced option).
December 28, 2012 at 4:29 am
When i use it, the login is created. But it is disabled.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply