"M" <raab@beethoven.com> wrote in message
news:%23PlfDkLcDHA.4020@tk2msftngp13.phx.gbl...
> I am using SQLDMO in an attempt to get a list of all the tables in a
> database.
> I am able to get a list of all the system tables, but none of the user
> tables. In fact, the call to dmosqlTables.ItemByID(i) fails for the user
> tables with the error "The ID 'n' was not found in the Tables Collection,
> where n is a number that is less than the Tables.Count value. For example,
> the call may work for values of n when n = 1,2,3,4,6,8,9,10 but fail for
n=
> 5,7
> I would appreciate any incite into this problem
> thank you very much
> M
>
>
>
> I wrote the folowing code in C#:
> dmosqlCurrDB =
(SQLDMO.Database2)dmosqlSqlServer.Databases.Item(strDatabase,
> "dbo");
>
> dmosqlTables = dmosqlCurrDB.Tables;
>
> int count = dmosqlCurrDB.Tables.Count;
>
> ArrayList al = new ArrayList();
>
> for (int i=1; i <= count; i++)
>
> {
>
> try
>
> {
>
> dmosqlCurrTable = (SQLDMO.Table2)dmosqlTables.ItemByID(i);
>
> }
>
> catch (Exception e)
>
> {
>
> Console.WriteLine(e.Message);
>
> continue;
>
> }
>
> al.Add((string)dmosqlCurrTable.Name);
>
>
>

> I am using SQLDMO in an attempt to get a list of all the tables in a
> database.
> I am able to get a list of all the system tables, but none of the user
> tables. In fact, the call to dmosqlTables.ItemByID(i) fails for the user
> tables with the error "The ID 'n' was not found in the Tables Collection,
> where n is a number that is less than the Tables.Count value. For example,
> the call may work for values of n when n = 1,2,3,4,6,8,9,10 but fail for
n=
> 5,7