Rookie,

Thanks for your concern and support.

Can you guide and assist me to trace out this error and query which are taking time.

  If cn.State <> 1 Then

       With cn

        .ConnectionString...

Dear All,

There is a demo for performance tunning on

http://www.sqlserverfaq.com/ and lots of tips which will give you help.

Have a Nice Day...

Regards,

Chirag