SQL Server

Get SQL Server Version/Edition Information

3 months ago
by Rob in

Just connect to the database in which you are interested, open a new query window, and enter the following query:

SELECT SERVERPROPERTY('ProductVersion') as 'Product Version',
SERVERPROPERTY('ProductLevel') as 'Product Level',
SERVERPROPERTY('Edition') as 'Edition'

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

1 year ago
by Rob in

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:

Table Design Change Warning

However, SSMS will actually let you perform such a change without have to drop the table and re-create it.  To enable this feature, you need to select Tools / Options from the Menu.  Then, navigate to Designers / Table and Database Designers and uncheck the option to “Prevent saving changes that require table re-creation”.

Enable Table Design Changes

Now click the OK button and try saving your table design changes.  Voila!

I owe a big thanks to my friend Jack for teaching me this trick.  It has saved me a lot of grief!

Go to Top