It is easy to find anything in Object Explorer, but how do you find every object where a string exists? Here is my chat with Vinod Kumar about it.
SSMS Keyboard Shortcuts Worth Learning
SSMS keyboard shortcuts for execution, comments, results, and Object Explorer remove repeated clicks while keeping query context visible.
SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2
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.
Script Table As in SSMS: CREATE, INSERT and SELECT in One Click
Script Table As is the right-click menu in SSMS that writes CREATE, SELECT, INSERT, UPDATE and DELETE statements for a table. This post shows what each option writes, what the scripts leave out, and how to run them safely.
Query Options in SSMS: Settings That Change Your Results
Query Options are the per-window settings in SSMS that change how a query runs and how its results look. This post covers results to grid, text or file, the character limits that cut long values, the SET options that change answers, and why SSMS and your application can disagree.
Commenting Out Code: Testing Safely in SSMS
Commenting Out Code is the quickest way to switch off part of a script while you test the rest. This post covers the SSMS shortcuts, testing one WHERE filter at a time, the trap of GO inside a block comment, and a safety note to leave above a DELETE.