Yes, I want sql to index my file content, because I want to do a content search on that...

Yes, Upgrade adviser is a good tool when Somebody wants to upgrade one server.

OK , I will upgrade my server this Friday.

I want to know what will happen next?

I will...

Ok, Now I have installed and run Upgrade Adviser.

There will be some errors, Most Of them on MS DB!:D

It is strange! why Microsoft Cant upgrade his product without any problem?

I...

Thanks dugi,

It was really helpful.

Dear Pradeep,

...so there is no way to restart it by jobs?

Probably because SQL Agent can't restart it self.

Am I right?

Dear Pradeep,

I know How to use sp_cycle_agent_errorlog in sqlserver2005 or 2008.

My problem is "there is no sp_cycle_agent_errorlog in sqlserver 2000".

So I have asked this question, also I have post...

Dear Gail,

Thanks for reply,

GilaMonster (11/6/2010)

It...

Thanks a lot lutz;)

I think your solution is great and I think it must change my way to thinking about queries.;-)

Sorry about wasting your time to learn how to upload...

Thanks dude;)

really helpful.

help please:(

...oh, ok I have change those...

I change my SP to a simple query which use temp tables as data.

You just need to change the "@KhorshidiDate" parameter to change the day...

help please

Dear Lutz,

Please accept my apology ,

know I have read your article and I have done that.

Attachment has all 3 tables in it - temp creation ,and temp data

2 of...

yes,I use Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)...

Dear Lutz,

I didn't mean that , and i know you help me and all people because of your kindness.

I will attache those immediately, and if i said something that...