SOAP and Content Databases

I built a little app that can create a SQL statement based on the list.

You can choose your site and list and it will match all the columns to
their names in Sharepoint.

The trouble I am having is getting to the server's configuration for
where the Content Databases are... I would like to be able to get the
sql server and database name for a specific list (or just a site).

Does anyone know how to do this? I would like to use the SOAP querry
but anything will do...

Thanks!

.

Relevant Pages

  • Re: SQL Statement
    ... I used the IN Clause to accomplish this. ... a sample for those of you wanting to know how. ... > connection string into the SQL Statement? ... Both databases are in Access ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: pySQLite Insert speed
    ... is not only faster on many databases, ... Thx. ... must have had something wrong in my original timing. ... Don't forget, by the way, that your original code was performing the string substitution of the parameter markers into the SQL statement each time the statement was executed. ...
    (comp.lang.python)
  • Re: Where to store SQL statement
    ... databases. ... Everytime I have to make a slight change to the sql statement, ... but I am concerned about the overhead of opening and ... reading a file just to get a SQL statement. ...
    (comp.lang.java.databases)
  • Where to store SQL statement
    ... I write a lot of JSP pages with backend classes to access MySQL ... databases. ... One of my biggest problems is having the SQL statements ... Everytime I have to make a slight change to the sql statement, ...
    (comp.lang.java.databases)
  • Re: opinion about a view
    ... > is an ActiveX dll written in VB6. ... In a humongous app, this view is used in ONE place, ... > the view with a SQL statement that performs the join. ... You didn't mention the database, but with some a 'view' doesn't ...
    (microsoft.public.vb.database)