Thanks for your reply Jeff.

I got clear pic .. thanks a lot...

one more doubt Jeff,

both the condition table is empty,

then why the where condition returns 'null'

and

group by condition returns...

use foreach loop container, map the folder and inside the container place a script task and write a code for count.

ForEachLoop ...

Please help me to resolve this issue..

Thanks for info. I tried what you instruct but i got an error.

TITLE: Microsoft SQL Server Management Studio

------------------------------

Attach database failed for Server 'ANANDH-HP'. (Microsoft.SqlServer.Smo)

For help, click:

I have tried to with ldf file also. I got the same issue.

Below the steps i followed to restore the database from disc.

step 1 : Logging sql server

step 2: Right...