Users/Groups Delete Disabled Users Delete Disabled Users Enum. Users Enum. Users Delete Users Add Users Enum. Groups Enum. Groups Change Groups Add Group Active Directory Enum. AD Groups Enum. AD Users List AD Users w/Prop Join AD Users NIC/IP Addresses Get IP Addresses Get IP Addresses Backup and Restore IP's Add IP's NIC Settings OS/Hardware OS Info Script OS Info Script All OS Info Script All OS System Count Hardware Info Script Hardware Info Script #1 Hardware Info Script #2 CPU Settings Enum. Printers Disk Quotas Disable Disk Quota Enable Disk Quota Disk Quota Query Disk Quota Update Shares/Files/Sessions Enum. Shares Enum. Shares Enum. All Shares Enum. Open Files Enum. Open Files Enum. Open Sessions Others Servers Uptime DNS Stuff Services Enum Services Enum Enum Processes Enum Hot Fixes MS FTP Server FTP VD Query FTP VD Delete FTP Site Enum. MS WWW Server WWW Site Enum. Enum Mime Types Enum Mime Types Application Pools Application Pool Enum Application Pool Enum Create Application Pool Create Application Pool Delete Application Pool Enum Apps in App Pool Enum App Pool Settings Move Apps Between App Pools Others IIS Component Probe IIS Status Enum SQL Dbases Backup SQL Dbases Orphan SQL Users List AD/WG My AD/WG Name My PC Name Enum AD Computers Contact Us Form SM Login Form Code Imail Login Form Code Enum. Domains in Imail Enum. Users in Imail CDONTS Component CDOSYS Component SA SMTP Component App Pool Monitor Ping and Tracert Hard Drive Monitoring Uptime Monitoring Desktop Lock CD Key Revealer MIK Restarter Site Map About the Site RSS Feeds I Read Custom Scripts Visitor #:     windowsadminscripts.com www     Script: Enumerate SQL Databases This script will enumerate all SQL Databases on a SQL Server Email Address To Send Sample Code To: @    '***************************************************** ' Script Written by Larry Heintz ' Dec 2007 www.windowsadminscripts.com ' This script will display all sql dbases on the ' sql server name you enter. ' ' usage cscript enumsql.vbs *will use local pc for server ' or ' usage cscript enumsql.vbs /computer:[sql server name] '***************************************************** Dim args,strDBServerName Dim objSQLServer,colDatabases,objDatabase Set args = Wscript.Arguments.Named if args.Item("computer") <> "" then strDBServerName = args.Item("computer") else strDBServerName = getComputer() end if 'Connects to SQL Server 'Displays all SQL Dbases Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName Set colDatabases = objSQLServer.Databases For Each objDatabase In colDatabases WScript.Echo objDatabase.Name Next set colDatabases = nothing set objSQLServer = nothing Function getComputer() Dim objNet Set objNet = WScript.CreateObject("WScript.Network") getComputer = objNet.ComputerName Set objNet = Nothing End Function Click Here to Download the VBS Script Copyright 2006 WindowsAdminScripts.com all rights reserved.