Try:

CREATE TABLE TableName (OptionNames varchar(2000))

INSERT TableName VALUES ('The following options are set for ' + @DBNAME + ': ')

INSERT TableName EXEC sp_dboption @DBNAME

The db name is not added at the...