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.
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.
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