there were few entries which are not table or atleast not created by me
like
MSpub_identity_range
there was other command that I used previously
select name from sysobjects where xtype = 'U' and status > 0 order by name
was there any error in this
Rajesh
>>how to get list of user defined table from the database
>
>You can uses information schema which conforms to SQL-92 Standard.
>
>SELECT * From INFORMATION_SCHEMA.TABLES
> WHERE table_type = 'BASE TABLE'
> AND table_name <> 'dtproperties'
>