Hi,

Thanks for your reply. i've tried and getting error :

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

can you suggest your opinion on this.

Thanks,

Regards,

Viji

Hi sbk.net,

It is cool that you can create two database and getting connected with the front end let it be ASP or anything and you can do such things by...

Hi Bob,

I'm happy that u checked for 'N/A' .

but first check for

Mngr1.sales_rep_manager <> 'N/A'

then check for

Mngr1.sales_rep_manager = Mngr2.sales_rep_name_control

bcoz it will take less time for checking N/A than...

say the first few either 3 or five are characters and the rest are numeric. and increasing and this will be the primary key for the table

-viji