Hi Sam,

Thanks for the reply. As per you instruction I have given permission for the reportservices. But still I am getting error that " Service unavailable".

Thanks,

Arooj

Hi Phil,

What does your proc actually do?

" Actually it is already built procedure. In that procedure we have written script it will serach the folder path where all excel...

Hi Taylor

Thanks for the support. But I did all the possibility what I could do in Sql Server like as you say , Activity Monitor, Sp_Who2 and I checked any...

Thanks to all for helping me on this issue. Now I got some idea to use MAXDOP.

Thanks a lot 🙂

Thanks Gail for your support 🙂

Yes Gail you are correct , each server is having 5 files , but the timing is differ. In one server where transaction load is less is maintaining 10 days...

Hi Gail,

Thanks for the reply,

Is there any way to maintain default trace file for a month or couple of months. Because when I seen each and every server is maintaing...

Thanks Lempster for your suggesation, but this one small application, User will be using very rarely. I believe that has been happened almost 15-20 days back and log is also...

Hi Lowell

Thanks for you valuable time. but still that user is not able to access any tables from the DB. I think the problem is in DB Structure only ,...

Hi All,

with the help of below script his name is showing in other DB but not in this DB

SELECT a.*,b.name as 'Login ID' FROM sys.database_permissions as A

inner join sys.server_principals...

when user is tried to access table that is not visible for him, only system table is displaying for him

Thanks for the reply both of you:)

I tried Grant view definition also but still its not working.:(

Thanks Shawn for you support 🙂

I apologize Shawn, You are correct , this error is coming SQL SERVER agent error log in Version 2005 SP2. By mistake I have posted this issue in this forum....

Thanks Gail for immediate response 🙂