Search results for query: *

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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