I finally got around to trying some of this stuff this morning. I figured using the IF EXISTS should be pretty easy to put in place.

Here is the new code.

IF EXISTS ('SELECT version_number

FROM '+ ''+@DB_Name+'' +'.dbo.schema_version

WHERE version_number LIKE ''4.%'' AND version_number NOT LIKE ''4.3%''')

BEGIN

....stuff

END

It kicks off his error though: Incorrect syntax near 'SELECT version_number

FROM '.

I am sure I probably have a quote out of place somewhere....