collation

---

you must use the appropriate ESCAPE_xxx macro

This entry was posted in SQL Server and tagged code collation sql agent jobs sql server agent troubleshooting on 26th June 2017 by Dimitri

Under some circumstances, your SQL Server Agent job mail fails with the following error message: “Unable to start execution of step 1 (reason: The job step contains tokens. For SQL Server 2005 Service Pack 1 or later, you must use the appropriate ESCAPE_xxx macro to update job steps containing tokens […]

---

Change Instance Collation on a SQL Server 2008 or higher

This entry was posted in SQL Server and tagged collation installation setup on 1st April 2015 by Dimitri

Important note before you start: If you perform this whereas there is already data, ALL DATA will be lost as the master, model and msdb databases are recreated during this procedure. In fact, all user databases will have to be re-attached and any link (like login to user) have to […]

---

---