How do I find out if my SQL server is 32-bit or 64-bit?

Want to know what version of SQL server your have running? All we need to do is execute one SQL command and away we go 🙂

  1. Go to your SQL server
  2. Open up the Microsoft SQL Server Management Studio
    1. Start->All programs->Microsoft SQL Server 2008 R2->SQL Server Management Studio
  3. Login with your user
  4. Click the New Query button
  5. Execute the following query
    1. SELECT SERVERPROPERTY('edition')

2 thoughts on “How do I find out if my SQL server is 32-bit or 64-bit?

  1. Pingback: SQL Server 2008 R2 – Updating a msSQL instance/server | Jack Stromberg

  2. Pingback: Lync 2010 – The feature: “Customizing security roles” is not supported in this edition of Reporting Services. | Jack Stromberg

Leave a Reply

Your email address will not be published. Required fields are marked *