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 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: DuncFair
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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?
  4. 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...
  5. 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...
  6. 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?

Part and Inventory Search

Back
Top