Thanks Gail for your valuable links...

Please vote every one. Then only the results may be accurate. Thanks for your participation.

Even the support for Sql server 2000 is discontinued. So i just eliminated the previous versions.

Now i got the execution plans .. i have to change the db .. i got it... Thank you all..........

i was given task identify long running queries and problematic queries.. but in the reults i got the above queries and none of the involve complex code or...

Thanks for every one for your valuable time in answering the issues i am getting.

Asked in the interview Gail.

Thanks for your help Sean....

Thanks Gail

1. How to apply all these recommendations all at a time. How to apply them.

2. How to verify which of them useful and which of them not useful. ...

Lynns answers are great ... my intention is the last question is not been answered . So if any one knows answer for the last question .. i want...

can any one please answers the unanswered questions.

Thanks Gail

It is running under NT Service\MSSQLSERVER . How to check permissions

I dont know about UNC path can any one help me where can i get the relevant information. how to use UNC path.