I agree if the issue is bad posts and posting to articles that are extremely old then their are better ways to deal with it thasn just changing the weight....

The problem comes from the fact that month() returns an int not a char, as does datepart. You will have to cast to a char to get it to work...

I agree with Steve and that is an awesome news letter which MS is trying earnestly to have surpressed. MS is not into open disclosure about specific issues until they...

quote:

---

Thanks a lot for the answer.

What would be the risks of debugging on production server?

Could profiler be of any help there (keep...

You know with as much pain as this is to do I wish they would take a hint and just fix it so the OS does the work for you...

First, what are you needing to do? You may not need to even kick the users out. If you absolutely do then Dons piece will get them out but you...

For dummies is the most generic and easiest to give a newbie. But don't forget there are companies that make video classes as well that may be helpful. I forget...

If just the client side an issue on one machine try reinstalling the client tools to see if corrects. Also, you did run the test vbs file from the client...

From BOL

quote:

---

Important If EXPIREDATE or RETAINDAYS is not specified, expiration is determined by the media retention configuration setting of sp_configure....

Unfortunately I could go on all day on potential issues outside of the hotfix. Specifically which hotfixes have you installed that you feel could be involved.

Also, take a look at...

MS Never blesses anything than can potentially allow the customers to run more than one technical copy of their software at one time.

As for processors and standard motherboard resources...

Which debugger are you referring to. TSQL debugger or Script Debuger, or other?

From SQL 7 BOL

quote:

---

extended memory size Option

The extended memory size option is available only for Microsoft® SQL Server™, Enterprise Edition running under...

Not sure, not running so I have no way to compare. Stop server and reboot then see if they come back quick.

I am such an idiot here is the problem and it is all my fault.

Change this

SET @sqlstr = 'if exists (SELECT @Description = [Description], @PopupText = PopupText FROM EDB.dbo.'...