Category: SQL Server

Get SQL Server Version/Edition Information

Just connect to the database in which you are interested, open a new query window, and enter the following query: For me, this produced the following: Product Version Product Level Edition 10.50.1600.1 RTM Enterprise Edition (64-bit)

Enable SQL Server Mgmt Studio to Overwrite Table Designs

By default, SQL Server Management Studio (SSMS) will not let you save changes to the designs of your tables.  When you attempt to do so, it wants you to drop and re-create the table.  You will typically see a dialog similar to the following: However, SSMS will actually let you perform such a change without …

Continue reading