Here's one for you guys. Since I don't have access to sql server tools how can I delete or make new tables in our sql database? I use asp to update/add/modify the contents of each exsiting table, but I need to add some new ones and delete some old ones. I hope someone can help me out on this matter.

Thanks

__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason

For Check Table Exsiting,Try.
<%
Private Function getTableName(xConn)
    Set xCommand = Server.CreateObject("ADODB.Connection")
    xCommand.Open xConn

    Set Rs = Server.CreateObject("ADODB.Recordset")
    Rs.ActiveConnection = xCommand
    Set Rs = xCommand.OpenSchema(20)
    While Not Rs.Eof
        If Rs.Fields(3).Value = "TABLE" Then
            getTableName = getTableName & Rs.Fields(2).Value & ","
        End If
        Rs.MoveNext
    WEnd

    Rs.Close
    Set Rs = Nothing
    xCommand.Close
    Set xCommand = Nothing
End Function
%>

<%
GetAllts = getTableName(xConnString)
Response.write "Tables List:" & GetAllts & "<BR/>"
If inStr(LCase(GetAllts),LCase("User_Table")) = 0 Then
    Response.write "Not Exsit."
Else
    Response.write "Exsiting."
End If
%>

Make new Table:

CREATE TABLE NewTableName (Field1 CHAR(5),Field2 VARCHAR(40))

Delete a Table:

DROP TABLE Table_Name

Thanks lilo, but I get an error when I try to drop a table

<%
Drop Table ServiceIndex
%>

It says expected statement, and points to ServiceIndex

What am I missing??