| My Tec Bits

How to exit from single-user mode in SQL Server database?

Sep 14, 2023 by Beaulin Twinkle

Exiting from single-user mode in SQL Server involves resetting the database to multi-user mode. Here’s how to exit single-user mode.

In SQL Server how to backup the database to a SQL script file?

Jul 4, 2023 by Beaulin Twinkle

Backup SQL Server database to a SQL script file

To backup a SQL Server database to a SQL script file, you can use the SQL Server Management Studio (SSMS). Here is the step-by-step instructions.

How to export a table to JSON file in SQL Server?

Jan 12, 2022 by Beaulin Twinkle

To export a table to JSON file, I have used FOR JSON clause to format the retrieved data as JSON and ran the BCP command through XP_CMSSHELL.

How to enable XP_CMDSHELL in SQL Server?

Jan 7, 2022 by Beaulin Twinkle

Enable XP_CMDSHELL to fix the error “SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component because this component is turned off”

How To Troubleshoot IntelliSense in SSMS

Dec 17, 2021 by Beaulin Twinkle

Troubleshoot IntelliSense - Enable In Settings

Here are a few techniques which I have used to troubleshoot IntelliSense In SSMS if it stops working for some reason.

Why am I unable to save changes after editing table design in SSMS?

Nov 25, 2020 by Beaulin Twinkle

Unable To Save Changes After Editing A Table Design In SSMS

Solution for unable to save changes after editing table in design window of SQL Server Management Studio.

Formatting SQL statements in SSMS

Dec 13, 2019 by Beaulin Twinkle

Formatting SQL statements or source code of procedures or function in SSMS is a daunting task. Here you will see how to use a plugin to format T-SQL in SSMS.

Reduce Index Fragmentation

Sep 13, 2018Aug 29, 2018 by Beaulin Twinkle

Here is the T-SQL queries to reduce index fragmentation by using either INDEX REORGANIZE or INDEX REBUILD. You will also see when to REORGANIZE and REBUILD.

Compatibility Level Field Is Disabled In SQL Server

Apr 17, 2018Apr 13, 2018 by Beaulin Twinkle

Unable to change SQL Server database compatibility level from management studio. Because the compatibility level field in the database properties window is disabled and grayed out.