Thank you very much Guys.This really helped me.

Mithra.

Thanks for the reply.

I am just having sqlserver instance level access and i dont have access to the node.Hence is there anyway to get the details with TSQL itself:

1) Total...

Yes Sean.That right.I need to create a sp in one of my test server and have that sp to pull all the details from another server in the network...

Hi Guys,

I read this article and it really looks very good.But i am not able to open the link 'SQL Server Instance Health Monitoring Tool'.Looks like the...

Thanks a lot,Thomas!!!!

John,ALZDBA,

Thanks a lot for your help.I got it now.

Mithra.

Hi John,

Thanks for your reply.Here i have only instance level access,So is it possible for me to get the info some sql logs ,wheater the node was restarted...

Not so urgent Ronald.Any help on this would do when you find time.This job is failing from long time with the same error.Thanks again.

Thanks Ronald. So it seems to be some problem with the indexes or data in the database...Either may be corrupted.. Am i rgt? How i can further proceed in this...

Thank you Moin Sir:-) I read this article today.;-)Just awesome.!!!!

--Boj

Hi Moinu,

Is there anyway to purge the audit file based upon the time stamp?

Thanks,

Boj.

Hi,

I mean viewing the report through the URL provided.

Hi,

I need to automate the report generation.It would be fine,If i could schedule the job to deploy and get the report to my mail.

Thank You!!

Thnks moin.Good piece of info. Boj:)

Thanks Bhuvnesh and Andrew!!!