Considerations for renaming a Data table field in ASP

Through the ASP program can modify the data table and the name of the field, so that the table can be a certain modification and maintenance.
SQL statement used: sp_rename ' customers. [Contact title] ', ' title ', ' COLUMN '
However, when used, a problem was identified that would cause an error when renaming a field name with the same name but with a different case:
15477 0 Note: Changing any part of an object name can corrupt scripts and stored procedures.
It seems to be renamed by the name of the object is still problematic, do not know whether there is no solution, this time also had to manually go to the library to change the field name ...