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!

Register Log in
  • Congratulations derfloh 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: *

  1. DuncFair

    xp_sendmail hangs

    Sorry, but that was just bad typing on my part. The comma is there in the real test. Any other ideas?
  2. DuncFair

    xp_sendmail hangs

    Wrote some stored procedures that utilize xp_sendmail for a client. Testing via query analyzer executed for 20 minutes before I cancelled. Tried a simple: exec xp_sendmail 'me@myemail.com' 'test' This hung (executed) for 10 minutes before I cancelled. The email address works fine and the...
  3. DuncFair

    sp_attach_single_file_db error

    Sorry. 1.) I don't have the exact error - it was on a client's machine accessed through two layers of terminal server (although I believe it specified files). 2.) No particular file 3.) Positive location info is correct - especially since I used the same physical file location info when I...
  4. DuncFair

    sp_attach_single_file_db error

    No multiple logs - just one 7-plus gig log file.
  5. DuncFair

    sp_attach_single_file_db error

    Running MSSQL7 on a WIN2 Server 1.) Detached db using sp_detach_db 2.) renamed db log file. 3.) ran sp_attach_single_file_db to reattach db with 'fresh' transaction log. error occurs stating that the execution has been cancelled because some of the tables could not be 'activated' I've never...
  6. DuncFair

    String truncated..?

    You don't have to see the line. Your simple insert query has tried to insert a string that exceeds the length allowed for the target column. If you set ANSI WARNINGS off, the query will run (and truncate the string or binary data).
  7. DuncFair

    Stored procedures/triggers to automatically run

    You could do it all in your SP if you add a call to xp_sendmail at the end of your procedure - something like this: ------------------------------------------- exec master.dbo. xp_sendmail @recipients = @contact_email, @subject = 'Happy Birthday!', @message = @text...
  8. DuncFair

    Initialize Com - could not create an instance of DTS Package

    That's the error I get after trying to run and/or create a DTS package to import a table from csv, via Enterprise Manager. Why can't I run or create and save a DTS Package when connecting to SQL Server Enterprise Manager ia a Citrix connection?
  9. DuncFair

    Edit SQL Server Notification text

    I know that allows user-defined text to be added to notifications, but what I need is to edit the default message because it is too long for my phone to be able to display the entire message. Is this possible, or do I need to have original email text captured, edited, and included in a 2nd...
  10. DuncFair

    back-up error

    Sorry, I should have replied to this myself at this point. The problem was that both Transaction log backups and differential backups were scheduled to run on the hour. When I pushed the Transaction log backup time schedule start time back ten minutes the errors disappeared. Thanks anyway for...
  11. DuncFair

    back-up error

    What is this? MS Support Knowledgebase did not turn up any matches. Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is...
  12. DuncFair

    SQL MAIL

    Terry, Maybe it's undocumented, but I know I got the answer from one of the multitude of forums I monitor. Unfortunately, I can't remember where. I have asked a client for whom I wrote a trigger that uses BOLD in text parameter to email me the script and I will post when I get it. As for the...
  13. DuncFair

    SQL MAIL

    1.) Sorry, but there ARE formatting options for xp_sendmail, I've actually used it in the past but can't remember the syntax. 2.) As far as the filetypes available for sp_processmail, I was actually looking for something beyond what is available in BOL (only TXT and CSV are mentioned). Thanks...
  14. DuncFair

    SQL MAIL

    Two Questions How can I format the text of a SQLMAIL email (bold, font,etc)? and What are the filetype options for sp_processmail?
  15. DuncFair

    New to SQL - Need help with Creating a table.

    Sounds like a plain vanilla DTS job. Is there a reason you're not using that? Dunc
  16. DuncFair

    Trigger to generate SQL Mail

    The following creates a trigger on a table that monitors a single column (Account Status), when the column is updated and email is sent to the contact telling them the old and updated Account Status values, as well as the user who made the change to their record...

Part and Inventory Search

Back
Top