hi,

yes..my logs are out of sync..its been more than 2000 mins, so I deleted and recreated, until i left work on friday it was working alright so hopefully it would...

Seems like no one has an answer for this ?

am still waiting... is there any document anywhere ?

thanks shashank...

 This list was sent to me by the third party Application vendor.

there are 750 rows, but I am trying to Avoid typing that 750 names in the where clause.like this

where...

thanks All,

am learning a lot on this site,and dare I say I always underated SqlServer as am more of an Oracle dba..but am excited with it...as microsoft seems to have...

thank you all for your feedback...I left it running last nite,came in this morning and it was bingo. I believe the server is just so slow....

thanks