This will also replace all temp table creates.

CREATE TABLE #SomeTable becomes ALTER TABLE #SomeTable.

Like Luis said, this is not an automated process.

Seems like regular expressions with patindex might work. ...