thanks.

So, can you tell me in what way i can restore it? is it not possibe?

thanks.

Jason,

I am not getting any error and i also selected the SSMS in the options but i could not see the SSMS installed.

Rahul

Thank you.

Sean Lange,

One more thing, is it necessary to check the temp table if it exists before droping it in the stored procedure?

Thanks a lot.

Yes,

I got it,

Thank you.

In my search i found out the following querys................

The query 1 will tell you the tables which are not being used by any of the stored procedures, functions, views........ etc....

I used the red gate tool (SQL compair) and it is very help full to find out all the differences between the databases.

Thanks again:-)

Rahul

Thank you all.........:-)

thanks all.