Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: yearnings
  • Order by date
  1. yearnings

    Public Folder Cann't be expand through System Manager

    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
  2. yearnings

    Exchange 5.5 Forwarding emails to another user

    Try distribution list
  3. yearnings

    Event Log Error - 8197/8204/8207

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

    Move mailbox

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

    Remove Outlook 2000 Mailbox

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

    Calling a SP inside another SP?

    Yes, you can do it GL.
  7. yearnings

    Cleaning mailbox

    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
  8. yearnings

    how to count first then find max??

    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)...
  9. yearnings

    how to count first then find max??

    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
  10. yearnings

    SQL maintenance plan did not run as scheduled

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

Part and Inventory Search

Back
Top