I think you need to copy the code given at the bottom under resources, and execute it from your SSMS.

Then run

EXECUTE [dbo].[WriteResultsToCsvFile]

@sqlcmd = 'select * from sys.objects'

,@filename = 'c:\object_export.txt'

You might get error that 'clr enabled' is disable and enable it. If you get that error then run these commands

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'clr enabled', 1

GO

RECONFIGURE

GO

Then run the above execute command to export the data into a file or you can change that select statement to what ever you want to export into a file.

I am not sure what this is doing in his script

"EXEC sys.sp_addextendedproperty" with his(Jonathan) user name but it is working for me.

GREAT WORK.