Smart Rename On Column Disappears

Windy City Girl

I tried to rename a column using Smart Rename - the tool starts and then disappears. I restarted the machine and tried a number of times with no success and I tried on a number of tables.

There are no cross db joins -

Thanks
Windy City Girl

Ben Pinchen

I've sent you a pm.

starsboss

I have noted that when a table column is referenced in a SQL 2000 table valued function (TF) the tool disappears whilst attempting to build the SQL...

Most annoying, come on RedGate any answers...??

JonathanWatts

Hi there,

Sorry about this problem that you are experiencing. We may have a patch that will fix this depending what version you are running. Can you tell me which version of SQL Refactor you are using?

Thanks,

Jonathan

starsboss

Jonathan I am running version 1.1.0.97

Thanks

JonathanWatts

I have sent you a PM regarding this.

Thanks,

Jonathan

PDinCA

Smart Rename of a column disappears for me too... v 1.1.0.97

PM please

JonathanWatts

Sent

Regards,

Jonathan

PDinCA

Well, it doesn't vanish any more but the script it generated leaves me thinking, "Huh?". There are 190 code objects Refactor believes are affected - WRONG! The column I'm renaming is referenced in FOUR CRUD SPs only... It's non-identifying, bit, with a default of zero. How could Refactor be so far off? Even if I count the tables it is foreign-key linked-to, that's 7 more tables, the SPs don't access any table remotely related to these 8...

I can email the script and describe what I'm actually changing if you'd like...

JonathanWatts

Hi PDinCA,

If you email me with all the details that you can I will investigate the issue for you and see where we get to.

Thanks,

Jonathan

BradleySmall

Vanishes on me too... Version 1.1.0.102

tanya

Hi Bradley,

Can you please contact support@red-gate.com and they will provide you with a patch which should resolve this issue.

Thanks,
Tanya