Combining North Pole with South Pole: JavaScript with SQL Server 2000 - How to get a list of all stored procedures (along with their source code) available in a SQL Server 2000 database using JavaScript
(Page 6 of 6 )
Now, let us develop a simple script (JavaScript) which shows the technique for retrieving all stored procedures available in a SQL Server 2000 database. The entire code for the sample is as follows:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/
intellisense/ie5">
<script id="clientEventHandlersJS" language="javascript">
<!--
functionButton1_onclick() {
var locator = new ActiveXObject ("WbemScripting.SWbemLocator");
var service = locator.ConnectServer(".","rootMicrosoftSQLServer");
var properties = service.ExecQuery("SELECT * FROM MSSQL_StoredProcedure
WHERE databasename='Northwind'");
var e = new Enumerator (properties);
document.write("<table border=1>");
dispHeading();
for (;!e.atEnd();e.moveNext ())
{
var p = e.item ();
document.write("<tr>");
document.write("<td>" + p.Name + "</td>");
document.write("<td>" + p.Text + "</td>");
document.write("</tr>");
}
document.write("</table>");
}
functiondispHeading()
{
document.write("<thead>");
document.write("<td>Name</td>");
document.write("<td>Text</td>");
document.write("</thead>");
}
//-->
</script>
</head>
<body>
<INPUT id="Button1" type="button" value="Button" name="Button1"
language="javascript" onclick="return Button1_onclick()">
</body>
</html>
The above code will automatically list all stored procedure names (along with the source code) available in the database "Northwind" of a SQL Server 2000 instance belonging to the client. To retrieve this information, I used a built-in class, "MSSQL_StoredProcedure," available in the "rootMicrosoftSQLServer" namespace. The "for" loop I used in the above code iterates for every stored procedure present in the SQL Server database and finally retrieves only the properties of that stored procedure.
Any comments, suggestions, bugs, errors, feedback etc. are highly appreciated at jag_chat@yahoo.com.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 7 
