We found the best way to do this is to :

1) Have a change request logged which includes the issue, the script to correct and a backup of the data....

You can also use QUOTENAME for this, but it does sound interesting!

SELECT QUOTENAME(Name, '''' ) + ',' FROM Users

I've found that, after being caught out a couple of times, ensuring 'script permissions' (Tools>Options>SQL Server Object Explorer > Scripting > Object Scripting Options > Script Permissions) is enabled is...