WhoWantsTacos
Programmer
I have a script of a couple of sprocs that involve some column names that have spaces in them. When I run the script on our test environment (includes the drop and create) it executes without issue. I can run the body of the sproc on production and it executes fine, however the process that we have to move things to production is suddenly transforming my column names that have spaces to append a . after every character so [First Name] becomes 'F.i.r.s.t. .N.a.m.e.' and then fails due to as an invalid name due to a null character.
Unfortunately, I don't have access to the DTS package that rolls our scripts into production but something is causing it to transform my column names. Does anyone have any idea what could cause this?
Thanks
Unfortunately, I don't have access to the DTS package that rolls our scripts into production but something is causing it to transform my column names. Does anyone have any idea what could cause this?
Thanks