Hi Mani,

Here is a a great article written by Gail aka GilaMonster.[/url] Check it out. It gives you a good idea what you need to do in case of DB...

I did make a dump stupid mistake though... I had the perfmon up and running from my desktop for the SQl Server. And then I restarted it. Now I dont...

This is probably a network login. Maybe MOM or Altris or some other software like that.

That is strange...If you are able to connect with SA, that means that the account exists. So this must be some other issue....

Yes Kash... Thats what you had to do...

I hope things work out with the issues.

Actually SA is a SysAdmin account created at the time of installing SQL Server. Do you know the password for that user SA? If so, Open SSMS (In SQL 2005)...

Usually when someone asks for a business reason why you are doing this or that, the OP usually runs out and here is one who actually gave a business reason....

I am not an expert and never claimed to be an expert. When ever I have asked for help, I always got it. So I try to give back with...

Since this is coming every 29 minutes without fail, I have a feeling that there is some monitoring service set up. Maybe MOM or some other software. This scheduled to...

First you will have to create a login and then grant access to DB that the user will connect. It can be a windows user or SQL User depending on...

Graeme, I do not think it is that easy to offend anyone here.. 😀

Yes, the cultural differences are there. But that should not be the reason why someone is...

I was not able to check this thread much yesterday since I had a late night shift the day before. I check today morning and this thread has grown like...

Thank you all for taking time and reading the article :).

Anything that is done in production environment should be done only after thinking it out and seeing if it...

I am not a big expert in tuning. But from what you say, it would be preferable to have the Clustered Index on month and suppler together.

Maybe one of...

Hey Noel,

Just wanted to update. The server was rebooted. The Log reader was stopped since the publisher was not there. I started it back on and everything is Green now..:)

Upgraded...