/*This script runs MS SQL 6.5 stored procedures to obtain information about the database and the server.
				Written By: Vito D'Astici 
				    Revised:4/6/2001                                   */


use master
print '------------'
print 'FREE SPACE '
print '------------'
exec xp_fixeddrives
go
print '-------'
print 'MEMORY'
print '-------'
go
xp_msver 'PhysicalMemory'
go

print '--------------------------'
print 'LOCATION OF THE DATABASES '
print '--------------------------'
SELECT  
NAME, PHYNAME
FROM SYSDEVICES 
go
print'-------------------------'
print'SIZE OF THE DATABASES'
print'-------------------------'
go
sp_databases
go
print '------------------------'
print 'DATABASE CONFIGURATION'
print '------------------------'
go
sp_configure 
go
select @@version

print '------------------------------------------------------------------'
go
sp_helpsort
go