JAVASCRIPT

Digging More into SQL Server 2000 Using Client-side JavaScript

This article mainly concentrates on retrieving SQL Server 2000 information using client-side JavaScript. It is a follow up to an earlier article that focused on retrieving stored procedure information. This article focuses on several other database objects.

Author Info:

By: Jagadish Chaterjee

Poor Best

Rating:

/ 13

May 23, 2006

TABLE OF CONTENTS:

· Digging More into SQL Server 2000 Using Client-side JavaScript
· How to retrieve all the parameter information of a stored procedure existing in an SQL Server 2000 database using JavaScript
· How to retrieve all trigger information (along with source code) existing in an SQL Server 2000 database using JavaScript
· How to retrieve database file information related to a particular SQL Server 2000 database using JavaScript
· How to retrieve all user data concerning a particular SQL Server 2000 database using JavaScript
· How to retrieve the user defined data types (in all databases) existing in a particular SQL Server 2000 instance using JavaScript

<!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">
<!--

function Button1_onclick() {
      var locator = new ActiveXObject ("WbemScripting.SWbemLocator");
      var service = locator.ConnectServer(".","rootMicrosoftSQLServer");
      var properties = service.ExecQuery("SELECT * FROM MSSQL_UserDatatype");
      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.DatabaseName + "</td>");
            document.write("<td>" + p.Name + "</td>");
            document.write("<td>" + p.BaseDataType + "</td>");
            document.write("<td>" + p.Length + "</td>");
            document.write("<td>" + p.MaxSize + "</td>");
            document.write("</tr>");
      }
      document.write("</table>");
}

function dispHeading()
{
      document.write("<thead>");
      document.write("<td>Database</td>");
      document.write("<td>Name</td>");
      document.write("<td>BaseDataType</td>");
      document.write("<td>Length</td>");
      document.write("<td>MaxSize</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 would automatically list all the user-defined data types existing in all databases within a SQL Server 2000 instance. To retrieve this information, I used a built-in class, “MSSQL_UserDatatype” available in the “rootMicrosoftSQLServer” namespace.

The “for” loop I used in the above code iterates for every data type present in an SQL Server instance and finally retrieves only the properties of that data type.

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.