The very quick one is select @@version. Another way is to take advantage of extended stored procedure xp_msver, for example, exec xp_msver ‘WindowsVersion’.
ClustrMap
-
Recent Posts
- Two ways to know the underlying OS version number by T-SQL
- Error: Login failed for user ”. Reason: Server is in single user mode. Only one administrator can connect at this time.
- Two quick tips to improve backup and restore performance from Brent Ozar
- Error: “Cannot generate SSPI context” when connect to a SQL Server instance after service account change
- How to connect to SQL Server Configuration Manager from another server
Archives
Categories
Meta
