When you execute a stored procedure from the object tree for a sql server that has parameters for datetime2, the generated command does not put ' single quotes around the values.