You are here: Home > Tips&Info, Windows > Find out MySQL and MsSQL on Windows

Find out MySQL and MsSQL on Windows

This might be helpful in case you are maintaining Windows server and need to find out whether your MsSQL and MySQL is applicable for patches or fixes from vendors, because sometimes Windows not displaying the exact version until application minor number.

To check Microsoft SQL/mssql version:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY
(‘productlevel’), SERVERPROPERTY (‘edition’)

To check mysqld server:
SHOW VARIABLES LIKE “%version%”;

Tags: , , ,

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS

Comments are closed.