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