List the Stored Procedures in a SQL Server database
发布时间：2016-12-30 来源：查字典编辑
摘要：ListtheStoredProceduresinaSQLServerdatabase.SupportedPlatformsSQLServe...
ListtheStoredProceduresinaSQLServerdatabase.
SupportedPlatforms
SQLServer2000
Yes
ScriptCode
strDBServerName="."
strDBName="Northwind"
SetobjSQLServer=CreateObject("SQLDMO.SQLServer")
objSQLServer.LoginSecure=True
objSQLServer.ConnectstrDBServerName
SetobjDB=objSQLServer.Databases(strDBName)
SetcolStoredProcedures=objDB.StoredProcedures
ForEachobjStoredProcedureIncolStoredProcedures
WScript.Echo"SPName:"&objStoredProcedure.Name
Next