I have100 databases with tbl, need to get count of enrolled records from tbl using pr

[saranyagunasekaran]

I have1000 databases with table called tbl1 which has got enrolled as column name, need to get count of enrolled records from tbl1 for all 1000 databases using procedures..... ........or it would be fine...if trigger is being set as soon as databases got created wuth tbl tbl1 and column enrolled to gine count.

get me the reply asap........... ...

[shabinesh]

Little extra clarity would be better. As far as i understood you have to create 1000 databases with names from tbl1. is it?