Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scripts of logins are not done properly Expand / Collapse
Author
Message
Posted Tuesday, December 25, 2012 11:28 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:55 AM
Points: 54, Visits: 555
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.
Post #1400149
Posted Tuesday, December 25, 2012 11:43 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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
Post #1400152
Posted Wednesday, December 26, 2012 10:49 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
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).
Post #1400464
Posted Friday, December 28, 2012 4:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 16, 2014 6:55 AM
Points: 54, Visits: 555
When i use it, the login is created. But it is disabled.
Post #1400869
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse