Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Rename of objects containing [ not working

I inadvertently put [] into lots of my column names and this broke RedGate. Google found something that might help explain:

I eventually fixed it by dropping the tables, which caused RedGate to run a create table statement rather than sp_rename.

https://connect.microsoft.com/SQLServer/feedback/details/509970/object-id-does-not-handle-object-names-with-square-brackets?wa=wsignin1.0

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
lakeland shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
under review  ·  AdminRedgate Administrator (Admin, Redgate) responded  · 

Hello,

What do you mean by “this broke RedGate.” How exactly did it break? Did you get any error messages?

Could you email Support@Red-Gate.com the table script that had the [] in the column names and what you changed it to? This will help us to reproduce the problem.

Thank you!

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • lakeland commented  ·   ·  Report

    It broke in that update would no longer work and the scripts SQL Source Control generated were not executable by SQL Server.

    I have now emailed Support@Red-Gate.com thanks