SQL08: Create a conditioned table using the data dictionary of SQL Server
Sometimes we need to check the existence of a table in a script or scheduled task to record error logs, first executions etc ...
Let us take an example, a package of integration services that normally distribute or run there where we go and that leaves traces in a custom table that is not the default for loading logs. We could always include a performance task or sql script, run right or wrong, as the first to run on the package and then continue. Being purists this just is not quite careful