Hi,

Table details can be displayed by executing system sp_help tablename in
query analyser.

I want to display the table details in web page by executing the same sp in
asp page.

Please help.

Thanks
William

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <william.sze@s...>
Subject: [asp_web_howto] sp_help


: Table details can be displayed by executing system sp_help tablename in
: query analyser.
:
: I want to display the table details in web page by executing the same sp
in
: asp page.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

<%
With objCommand
    ...
    .CommandText = "master.dbo.sp_help"
    .Parameters.Append .CreateParameter("objName", adVarChar, adParamInput,
776, strTableName)
End WIth

Set objRS = objCommand.Execute
%>

Does that work?

Cheers
Ken

Ken,

I tried:

<%

Dim objCommand
set objCommand = server.CreateObject("ADODB.Command")

With objCommand
    .ActiveConnection = strConn
    .CommandType = adCmdStoredProc
    .CommandText = "master.dbo.sp_help"
    .Parameters.Append CreateParameter("@objname", adVarChar, adParamInput,
776, "area")
End WIth

Set objRS = objCommand.Execute

%>

However, it gives me error:

                                              
                       ADODB.Command          
                       (0x800A0BB9)           
                       Arguments are of the   
                       wrong type, are out of 
                       acceptable range, or   
                       are in conflict with   
                       one another.           
                                              




area is the table name.

Any idea?

Thanks
William


                                                                                                                   
                    "Ken Schaefer"                                                                                 
                    <ken@a...       To:     "ASP Web HowTo" <asp_web_howto@p...>                      
                    tic.com>             cc:                                                                       
                                         Subject:     [asp_web_howto] Re: sp_help                                  
                    03/26/2002                                                                                     
                    09:15 PM                                                                                       
                    Please respond                                                                                 
                    to "ASP Web                                                                                    
                    HowTo"                                                                                         
                                                                                                                   
                                                                                                                   




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <william.sze@s...>
Subject: [asp_web_howto] sp_help


: Table details can be displayed by executing system sp_help tablename in
: query analyser.
:
: I want to display the table details in web page by executing the same sp
in
: asp page.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

<%
With objCommand
    ...
    .CommandText = "master.dbo.sp_help"
    .Parameters.Append .CreateParameter("objName", adVarChar, adParamInput,
776, strTableName)
End WIth

Set objRS = objCommand.Execute
%>

Does that work?

Cheers
Ken



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20