Showing posts with label identify the sql server edition. Show all posts
Showing posts with label identify the sql server edition. Show all posts

how to identify the sql server edition

select serverproperty('edition')
The result will look something like:
32-bit: Enterprise Edition
64-bit: Developer Edition (64-bit)

Determine Size of a Table in SQL Server

sp_spaceused ‘Tablename’