Thank you guys for the info.GRE thank you for the link.I modified the code to pull failed backups.works like a charm.

thank you all for all your valuable input.this has helped me setup something close to what i was looking for.:-)

Thank you for the reply paul.Man if i knew how to accomplish what i described in my post I would not have posted it:-D.Unfortunately I do not have the skills...

Thank you grant for the info.

thank you Lowell for the info.I did not know the sp_foreach db is using cursors in the background.You are right Since I am using this code only once to turn...

From a perfomance prespective I would want to avoid using cursors.What do you guys think is the best approach?

thank you lowell.

thank you Florian .Your code worked great .

I tried using running and I get errors

sp_MSforeachdb

'

ALTER DATABASE [''?''] SET AUTO_CLOSE OFF WITH NO_WAIT

'

Msg 5011, Level 14, State 5, Line 3

User does not have permission...

Thank you Greg

thx for the reply mate.

I know #2 is laughable.I had to control laughing when my boss wanted to do this,but what can I say .I am new in the company...

Thank you Imran.

Lowell,Thank you very much.I got what i was looking for and more.:D

Lowell, thank you for your quick reply.

Unfortunately I cannot open up the script you attached .Can you paste the entire code in the post.

thanks