Results 1 to 2 of 2

Thread: XP_Sendmail

  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: XP_Sendmail

    I'm using XP_Sendmail on an NT Server and it works fine. We have a new Windows 2000 server, which the SQL Mail has been set up correctly, and the test passes.

    When I use execute xp_sendmail in the query analyzer on the 2000 server, it just sits there and processes for over an hour, without any error messages.

    Has anyone seen this before?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check the status of that processess on the Current activity and if its SLEEPING and no blocking to other connections then ignore the contents.

    Check SQL server error log for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •