Menu
I have SQL Server 2008 installed, but I'm not sure what license was installed. Is there an easy way to find this out?
336
Method 1: Check SQL Server Version Using T-SQL Where server_name is your server name and instance_name is the SQL instance name. If you're trying to connect to the default instance, just type SQLCMD. This will display the version and license type of your connected SQL Server instance.
It depends on the SQL server license that you buy. You can check the information from SQL server error log. For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist.
Check whether SSMS will expireStart SQL Server Management Studio. Select the Help menu and then the About... submenu from the list. You will run into the problem discussed in the article if the component Microsoft SQL Server Management Studio has expires in 'x' days next to it.
I presume you mean via SSMS?
For a SQL Server Instance:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') For a SQL Server Installation:
Select @@Version
186
This shows the licence type and number of licences:
SELECT SERVERPROPERTY('LicenseType'), SERVERPROPERTY('NumLicenses') If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
