Part 2 shows another way to rename a table name that contains [ or ] identifiers, after sp_rename fails with a Msg 15253 syntax error.
![SQL SERVER - Rename a Table Name Containing [ or ] in the Name - Identifier in the Table Name](https://blog.sqlauthority.com/wp-content/uploads/2014/01/renameerror2.jpg){kind=small}
SQL SERVER – Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name
My colleague renamed a table to [] by accident and sp_rename failed. Here is how to rename a table name containing [ or ] characters.
Case-Insensitive and Multiline Regex Flags in SQL Server 2025
Your pattern passed the test string and then missed rows in the table. The flags and the line endings are the usual reason.
SQL SERVER – Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server
The VALUES clause does much more since SQL Server 2008. Here is a Query Plan Analysis of PIVOT and UNPIVOT queries using the profiler in dbForge Studio.
SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012
Worried about your database while on vacation? John Sterrett shows how Policy Based Management helps a proactive DBA catch unwanted changes.
Comparing Two Database Schemas With T-SQL
Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.
Checking Data Type Mapping After a Database Migration
Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.