Recent content by yearnings

Please take a look at the following article: 319240 You Cannot Manage Public Folders by Using Exchange System Manager http://support.microsoft.com/?id=319240 325923 You Cannot Expand Public Folders Through Exchange System Manager http://support.microsoft.com/?id=325923

Try distribution list

Hi spooties, You should have a look at the following article: http://support.microsoft.com/?id=271410 Best Regards

Hi, The following article may be helpful http://support.microsoft.com/?id=328810 Best Regards Glen

Hi wmggdm Try Control panel-->Mail-->Services -->Show Configurations BTW:I use Chinese version, so the name may be not exact.

Yes, you can do it GL.

Hi h1234, I Know little about SQLMail, but I think your script should be: declare @hMessage varchar(255) exec master..xp_findnextmsg @msg_id=@hMessage OUT while @hMessage is not null begin exec master..xp_deletemail @hMessage exec master..xp_findnextmsg @msg_id=@hMessage OUT CONTINUE end

Hi mhuma, I think another question, If there are two or more states have equal number of customers, using "TOP 1" will not get all the results, another query like this: Select StateId, Total From (Select StateId, Count(StateId) As Total From Customer Group By StateId)...

I think it can get the result you want Just like this: Select Top 1 State, Total From (Select State, Count(*) as Total From Customer Group By State) State_Customer_Num Order By Total Desc

I know one of the reason is losing of the Sqlmaint.exe, or your maintaince plan is not correct