Agus Wijiyanto

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual experience color theme options) really got me excited. To do this you have to edit system files, don’t get me wrong, it obviously is not a supported means to get the dark theme but I was curious to experience it. Here are the steps for SSMS 17. Navigate to C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\ Look for ssms PKGUNDEF File (Like the below) Search for // Remove Dark theme header and what you need to do is comment the whole block out with // SAVE FILE Restart SQL Server Management Studio and head to Tools > Options to  select the dark theme . This is what you will get. It does look like a work in progress. The connection and results pane seems to still be white but I still like it! Note: If the above does not work you may need to open notepad (Run as Admin) then navigate to the PKGUND...

Applies to ApexSQL Complete Summary This article describes how to set a custom connection color to a query tab in Microsoft  SQL Server Management Studio  (SSMS) using a feature called  Tab coloring  in ApexSQL Complete. Description Tab coloring can set custom connection colors for individual instances of SQL Server, down to the database level. The user has ability to assign SQL servers, and databases to a specific environment to help quickly identify which connection a tab is currently using.

Automatically complete SQL statements Review an object's script and description Improve productivity with snippets Identify the structure of complex SQL queries Keep track of all your tabs Log every executed query Easily navigate to SQL objects Check queries in test mode Color query tabs by environment Search and export query results Create CRUD procedures Guard against queries that may damage data source :  https://www.apexsql.com/sql_tools_complete.aspx

Table System Information She Sql Server SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_SCHEMA = N'dbo' AND SPECIFIC_NAME = N'getCustomer'