When right-clicking and selecting modify on a stored proc in SSMS 2014, the script is generated in a new window but uses the sp_executesql statement with the Unicode N' format. I've never had this happen in previous versions of SSMS but I'm hoping it's just a setting I may have changed unintentionally. As an FYI, what I am wanting is that when I right click to modify a stored proc, that it is generated in a new window (works fine now) but doesn't enclose everything in the N' format so I can easily copy and paste portions of the script or modify them without having to put the extra ' marks around in char values in the proc.
I am not sure how it looks like in SSMS 2014 but in 2008 R2 it's under Tool --> Options --> SQL Server Object Explorer --> Scripting and the option is called Include IF NOT EXISTS clause. Set it to False!