Wednesday, 22 January 2014

How can i know what type of Sql Server version using in my machine

You can know by using the bellow commands:

1. SELECT @@VERSION---You can get the total details of your Sql server.

2. SELECT SERVERPROPERTY('Edition')---You can get only Edition name of your Sql server. like Standard,Developer etc.

3. SELECT SERVERPROPERTY('EditionID')---You can get only Edition IDof your Sql server. like -1534726760,-2117995310 etc.

No comments:

Post a Comment