Hi,
thanks again.... for the undocumented command... ^.^


>>Is there a fast way or command to compare 2 database to have all the same record count in all the tables ?
>>
>>Thanks in advance.
>
>Look at using sp_MSForEachTable
>
>You can try running
>

>execute sp_MSForEachTable 'declare @Cnt int select @Cnt = count(*) from ?  print '' ?: '' + cast(@cnt as varchar(10)) '

>
>and then compare the output.
>
>Unfortunately, the tables are not in alphabetical order.