Scripts of logins are not done properly

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Scripts of logins are not done properly

Scripts of logins are not done properly

Rate Topic

Display Mode

Topic Options

Author

Message

rajkiran.panchagiri

Posted Tuesday, December 25, 2012 11:28 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 26, 2013 4:15 PM
Points: 39, Visits: 402

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

Bhuvnesh

Posted Tuesday, December 25, 2012 11:43 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

see here http://weblogs.sqlteam.com/billg/archive/2010/07/08/Scripting-out-SQL-Server-Logins.aspx

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1400152

Posted Wednesday, December 26, 2012 10:49 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 3:36 AM
Points: 305, Visits: 493

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

rajkiran.panchagiri

Posted Friday, December 28, 2012 4:29 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 26, 2013 4:15 PM
Points: 39, Visits: 402

When i use it, the login is created. But it is disabled.

Post #1400869

« Prev Topic | Next Topic »

Permissions