Loop Through every table in a DB

this Script is meant to be used to create your own script and by itself it does very little except list all the tables. the parameter @SQLScript can be used to execute some code as you see fit.

the idea behind this script is to use it as a template to build your own code.

this is based on the original sp called _SPLOG_SPConstructor found in the autogenerate stored procedures code which can be found here:

http://www.sqlservercentral.com/scripts/AutoGenerate/65042/

and here:

http://www.sqlservercentral.com/scripts/AutoGenerate++++++parameters/64760/

Enjoy...