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/