DEPLOY REQUIREMENTS AND ISSUES
Be sure of something: if you have different environments, the same code that runs successfully were was born in, may fail on a new environment due many causes, like version differences and other system’s idiosyncrasies .
So, rule of thumb: always assume that a deploy on a new environment requires full testing procedure.
Below, it is shown an example.
DEPLOY – ENVIRONMENT DIFFERENCES
SQL command executed successfully in a Local SQL Server 2012 instance installed at Nov, 2018.
The same command fails on a server using a prior version of SQL Server.
Brazilian system analyst graduated by UNESA (University Estácio de Sá – Rio de Janeiro). Geek by heart.