Wednesday, February 16, 2005

How is your Server Configured

The following script works well on Sql Server 2000 (I have not tested it w/ any other versions). The purpose is to gain as much information back on how your sql server is configured (general settings memory etc.)

print 'Free Space'
print '----------'
exec master.dbo.xp_fixeddrives

print 'Memory'
print '------'
exec master.dbo.xp_msver

print 'Database Configuration'
print '----------------------'
exec master.dbo.sp_configure

print'DB Size'
exec master.dbo.sp_databases

print 'Linked Servers'
print '--------------'
exec master.dbo.sp_helplinkedsrvlogin

print 'Windows info'
print '------------'
exec master.dbo.sp_server_info

No comments:

Post a Comment