List all the Databases on a SQL Server
发布时间:2016-12-30 来源:查字典编辑
摘要:ListalltheDatabasesonaSQLServer.SupportedPlatformsSQLServer2000YesScri...
ListalltheDatabasesonaSQLServer.
SupportedPlatforms
SQLServer2000
Yes
ScriptCode
strDBServerName="."
SetobjSQLServer=CreateObject("SQLDMO.SQLServer")
objSQLServer.LoginSecure=True
objSQLServer.ConnectstrDBServerName
SetcolDatabases=objSQLServer.Databases
ForEachobjDatabaseIncolDatabases
WScript.EchoobjDatabase.Name
Next