Flaw in sp_helpdb by TonyBell2

Currently the master..sp_helpdb stored procedure does not take into consideration that there may be databases with no owner associated with them. When executed it returns the following error:

Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100003401'; column does not allow nulls. INSERT fails.
The statement has been terminated.

This error is caused by the statement:

insert into #spdbdesc (dbname, owner, created, dbid, cmptlevel)
        select name, suser_sname(sid), convert(nvarchar(11), crdate),
            dbid, cmptlevel from master.dbo.sysdatabases
            where (@dbname is null or name = @dbname)


This issue can be corrected by changing the statement to read:

insert into #spdbdesc (dbname, owner, created, dbid, cmptlevel)
        select name, isnull(suser_sname(sid),'~~UNKNOWN~~'), convert(nvarchar(11), crdate),
            dbid, cmptlevel from master.dbo.sysdatabases
            where (@dbname is null or name = @dbname)