欢迎来到福编程网,本站提供各种互联网专业知识!

List all the Databases on a SQL Server

发布时间:2007-06-21 作者: 来源:转载
ListalltheDatabasesonaSQLServer.SupportedPlatformsSQLServer2000YesScriptCodestrDBServerName="."SetobjSQLServer=CreateObject("SQLDMO.SQLServer")objSQLServer.LoginSecure=TrueobjSQLServer.ConnectstrDBServerNameSetcolDatabases=objSQLServer.
ListalltheDatabasesonaSQLServer.

SupportedPlatforms

SQLServer2000
Yes


ScriptCode

strDBServerName="."

SetobjSQLServer=CreateObject("SQLDMO.SQLServer")
objSQLServer.LoginSecure=True
objSQLServer.ConnectstrDBServerName

SetcolDatabases=objSQLServer.Databases

ForEachobjDatabaseIncolDatabases
WScript.EchoobjDatabase.Name
Next

相关推荐