The Ns are Unicode constants, provided by SQL-92 standars.
From BOL spanish:
"Las constantes Unicode se especifican con una N a la izquierda: N'Una cadena Unicode'." >You could try this as well:
>>
>>>>LOCAL lcSQLScript, loConnection
>>
>>loConnection = CREATEOBJECT('ADODB.CONNECTION')
>>loConnection.Open("Provider=SQLOLEDB.1;User ID=MyUserName"+;
>> +";PWD=MyPassword"+;
>> +";Persist Security Info=False"+;
>> +";Initial Catalog=MyDatabaseName"+;
>> +";Data Source=MyServerName")
>>
>>lcSQLScript = ;
>>"BACKUP DATABASE [MyDatabase] TO DISK = N'C:\Backups\BackupFilename' "+;
>>"WITH INIT , NOUNLOAD , NAME = N'MyBAckupName', NOSKIP , STATS = 10, "+;
>>"DESCRIPTION = N'MyBAckupName', NOFORMAT "
>>
>>loConnection.Execute(lcSQLScript)
>>>Thank you. Very educational.
>What is the significance of those Ns in front of the quotes?
