Yes all the databases 'set auto-close' option is on. This is the requirement of application hence set to on. We have almost 2000 databases.

We could see some set of databases...

Thanks a lot for your replies. I'll definitely do the trial and error on the test server and would like to come up with specific questions.

So my first question -

1)...

Thanks for all the replies.

Actually this is one time activity. So we don't want to pay much attention towards optimization of this stored procedure.

But in case if it is possible...