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://secure.gravatar.com/avatar/bb93073c9137610d398aba72bfef0ad5?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
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!
-
lakeland commented
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