• You have to run the script for each database.

    Also I get an error when running the script.

    Msg 911, Level 16, State 1, Line 33

    Could not locate entry in sysdatabases for database '' + DB_NAME() + ''. No entry found with that name. Make sure that the name is entered correctly.

    I need something that script out a Login and it's their fixed database roles for all Databases on a SQL Server Instance.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/