List the Stored Procedures in a SQL Server database

(编辑：jimmy 日期: 2026/5/7 浏览：3 次 )

List the Stored Procedures in a SQL Server database.

Supported Platforms

SQL Server 2000
Yes

Script Code

strDBServerName = "."
strDBName = "Northwind"

Set objSQLServer = CreateObject("SQLDMO.SQLServer")
objSQLServer.LoginSecure = True
objSQLServer.Connect strDBServerName

Set objDB = objSQLServer.Databases(strDBName)
Set colStoredProcedures = objDB.StoredProcedures
For Each objStoredProcedure In colStoredProcedures
WScript.Echo "SP Name: " & objStoredProcedure.Name
Next

上一篇：比较不错的一款图片广告效果
下一篇：用jscript实现列出安装的软件列表