Skip to content
  • Facebook
  • GitHub
  • YouTube
  • Pinterest
My Tec Bits
  • Home
  • Microsoft
    • .Net
      • ASP.NET
      • MVC
      • Visual Studio
    • IIS
    • SQL Server
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012
      • SQL Server 2008
    • Windows OS
  • Web Development
    • Java Script
    • Jquery
    • Python
    • Bootstrap
    • Zurb Foundation
    • Web Security
  • More
    • macOS
    • Reviews
  • Online Tools
    • Fitness Calculators
    • Encoders & Decoders
    • Cryptography
    • Unit Converters
    • Math. Calculators

SQL Sever Management Studio (SSMS)

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

Nov 25, 2020Nov 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.

Categories Others, SQL Server Tags SQL, SQL Server 2019, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment

Formatting SQL statements in SSMS

Dec 13, 2019Dec 13, 2019 by Beaulin Twinkle
After Formatting SQL Statements in SSMS

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.

Categories SQL Server Tags SQL, SQL Sever Management Studio (SSMS), SQL Tips, Transact-SQL (T-SQL) Leave a comment

Reduce Index Fragmentation

Sep 13, 2018Aug 29, 2018 by Beaulin Twinkle
Reduce Index Fragmentation - Reorganize Indexes popup window

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.

Categories SQL Server Tags SQL, SQL Server 2017, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment

Compatibility Level Field Is Disabled In SQL Server

Apr 17, 2018Apr 13, 2018 by Beaulin Twinkle
SQL Server Compatibility Level Disabled

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.

Categories SQL Server Tags Database, SQL, SQL Sever Management Studio (SSMS), SQL Tips, Transact-SQL (T-SQL) Leave a comment

Auto Generate INSERT Statements for a Table in SQL Server

Aug 18, 2018Dec 27, 2017 by Beaulin Twinkle
Auto Generate Insert Script in SQL Server 05

Easy way to auto generate INSERT statements for a table in SQL Server using SSMS. Generate insert statements from sql server tables on the fly.

Categories SQL Server Tags SQL, SQL Server 2016, SQL Server 2017, SQL Sever Management Studio (SSMS), SQL Tips 4 Comments

SQL Server Development And Management Tools

Aug 18, 2018Nov 29, 2017 by Beaulin Twinkle
SQL Server Development And Management Tools

Top SQL Server Development And Management Tools. List of few popular tools which can be used for MS SQL Server development and management.

Categories SQL Server Tags Azure SQL Database, MSSQL-CLI, SQL Operations Studio (SQLOPS), SQL Server Data Tools (SSDT), SQL Sever Management Studio (SSMS), Visual Studio Code 1 Comment

Installing SQL Server Management Studio (SSMS)

Aug 18, 2018Aug 9, 2017 by Dahlia Sam
Installing SQL Server Management Studio SSMS

SSMS for SQL Server 2016 and higher. Installing SQL Server Management Studio Release 15 and higher for SQL Server 2008 or higher.

Categories SQL Server Tags SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Sever Management Studio (SSMS) Leave a comment

Article Categories

  • Android (2)
  • Apple (16)
    • macOS (16)
  • Internet & Web Dev. (127)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • Python (65)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (2)
  • Microsoft (263)
    • .Net (59)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (181)
    • Windows (22)
  • Networks And Distributed Systems (2)
  • Oracle (4)
    • Oracle Database (4)
  • Others (4)
  • Reviews (10)

Recent Articles

  • Finding triggers on table or schema in SQL Server DB Feb 26, 2021
  • Escaping square brackets in LIKE clause in SQL Server Feb 17, 2021
  • FOR LOOP in SQL Server? Feb 7, 2021
  • Search the whole database for a string in SQL Server Jan 29, 2021
  • How to avoid the error “string or binary data would be truncated” and insert string with truncation in SQL Server? Jan 18, 2021
  • How to execute SQL Server stored procedure from Python? Dec 18, 2020
  • Error: ‘SqlConnection’ could not be found in the namespace (Solved) Dec 11, 2020
  • How to execute an SQL Server stored procedure from a C# program? Dec 11, 2020
  • Why am I unable to save changes after editing table design in SSMS? Nov 25, 2020
  • GETDATE() vs CURRENT_TIMESTAMP in SQL Server Nov 18, 2020

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators

Popular Articles

  • SQL Server: Concatenate Multiple Rows Into Single String
  • How To Get Day Of Week In SQL Server?
  • Find Indexes On A Table In SQL Server
  • How To Add Bootstrap In ASP.NET (MVC & Web Forms)
  • SQL Server: Search and Find Table by Name
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. Learn more...
  • Home
  • About Us
  • Contact Us
  • Site Map
  • Terms Of Use
  • Privacy Policy
© 2012 - 2021 My Tec Bits. All Rights Reserved.
Scroll back to top