SQL Server Export Logins to Report RPT file

SQL Server offers unique benefit of exporting all its logins onto a report file which is usually stored in rpt format. This is an important task to be completed before SQL Server update install (or) upgrading SQL server as a whole. This proactive measure, preserves logins in case of upgrade failure (Mostly updates have less impact on logins but can’t be discounted)

Perform the following steps to import logins onto report file

1) First try to find details on logins in server as follows

select * from syslogins

2) Now highlight the above SQL, right click and choose option that says, results to file. Click Execute

3) Save the report file that is of rpt format

To get back results in SSMS choose results grid