>>That is my understanding too.
>
>Thanks, I will keep the script generator as is.
If the field is defined as nvachar(...) you don't really need to add N' in front as the field still will be nvarchar. You need N' if you use unicode characters.
sp_ExecuteSQL requires nvarchar parameters (Command to execute and Parameters Definition)
If it's not broken, fix it until it is.
My Blog