1
Vote

Issue - Handle Table Names with Spaces

description

Hi,

In order to handle tables with spaces in their names, a few changes are required. ( I dont have rights to change the database naming convention as its a 3rd party DB.)

In a few places we need to use QUOTENAME on the @SourceName and construct the trigger name differently.

I attach my updated procs in case you want to include in the source version.

I also removed the system object flagging due to my continual modifications until I had it working.

The changes are now working in my DB.

Thanks,
Steve

file attachments

comments