Hi James,

Thank You very much. It works fine for me.

Thank You Sergey and Antares686 for your valuable help sorry for late reply.

Hi Sergiy,

Just now i tried the query. In my case the description column is like this.

Passed on 02 Mar 2007

Passed on 02 Mar 2007

Failed on 02 Mar 2007

Failed on...

Thank You Sergiy

Hi Uddin,

I solved out the problem.I changed the job schedule daily now it is working.Thank you for your response.

Hi Uddin,

Thank You very much for your response.

I set it as no end date and i have two jobs running on same intervels. Is this wrong?

Hai alzdba & Journeyman,

Those tables are user tables they start with different letters.Linux application is working fine.

There was no time gap. Just i took the backup and restored the...

Hi,

Some where i read in this forum, but i did't tried this one. You try this and if it works post in the forum

Go to the registry.

HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\80\TOOLS\SQLEW\REGISTERED SERVERS...

Hi,

I will give you suggestion. Write a procedure and use cursor in that for check the accounts table according to your criteria and run this procedure in job schedule on...

Hi Jeff,

Sorry for late giving reply 'n' thank you very much for your answer. I found out the problem.

Hi ,

Thank You very much all for your suggestions.

Hi Karl,

You are simply Genius. It's worked very well.

Keep it up.Thank You Friend.

Thank U Sqlservercentral.com people.

Hi Karl

Good Morning, You are simply superb. The code is working.I have one more doubt on sp_msforeachtable. I am writing this code for deleting temporary files names starts with TMP...

Hai Karl,

Good Morning and Thank U Very much for your answer, but i am getting an error when running the update statement. It is looking all the tables even...