Some basic queries In SQL Server

Updated: Mar 18

1. Retrieve List of All Database

EXEC sp_helpdb 

List of All Database

2. Get the version name of SQL Server

SELECT @@VERSION AS Version_Name  

Server Version

3. Get Current Language of SQL Server

4. Return Server Name of SQL Server.


Server Name

5, Retrieve Free Space of Hard Disk.

EXEC master..xp_fixeddrives 

Free Space

6. Get First Date of Current Month


Need any help in SqlServer Please contact us

If you like Codersarts blog and looking for Assignment help,Project help, Programming tutors help and suggestion you can send mail at

Please write your suggestion in comment section below if you find anything incorrect in this blog post

Contact Us

Tel: (+91) 0120  4118730  

Time :   10 : 00  AM -  08 : 00 PM IST 

Registered address: G-69, Sector 63, 

 Noida - 201301, India

We Provide Services Across The different countries

USA    Australia   Canada   UK    UAE    Singapore   New Zealand    Malasia   India   Ireland   Germany

Terms and Conditions        Privacy Policy    Pricing Policy       Refund Policy         COPYRIGHT © 2021

Sofstack Technology Solutions Pvt. Ltd.

  • CodersArts | Linkedin
  • Instagram