DBAmen

This blog is for newly appointed DBAs to view solutions and suggestions to tackling a range of problem. I aim to provide How To guides rather than extensive volumes on theory and concept.

Tuesday, 3 April 2012

Which version of SQL Server do I have?

From within SQL Server Management Studio, simply click the New Query button and type:

SELECT @@VERSION


Hit return and there you have it.
Posted by Peter J Quinn at 22:02
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2012 (26)
    • ▼  April (26)
      • Jobs and Maintenance Plans
      • Alerts and Errors
      • How to restore system databases
      • How to restore a user database
      • SQL Server Architecture
      • Planning Server Resource Requirements
      • How to setup Notifications
      • How to setup Database Mail
      • Transaction Log Shipping
      • SQL Server Agent
      • Integrity check
      • SQL Profiler
      • Central Management Servers
      • SQL Trace
      • Database structure
      • Creating Indexes
      • User Access to Objects
      • Server and Database Roles
      • The msdb database
      • Activity Monitor
      • How to create logins
      • Backing up databases
      • A quick overview of database backups
      • New DBA checklist
      • Which version of SQL Server do I have?
      • In the beginning
Peter J Quinn. Ethereal theme. Powered by Blogger.