Viewing 15 posts - 1 through 15 (of 24 total)
We encountered the same error on a server using outlook 2003.
This is due to the use of Outlook 2003 as the mail client. Outlook was configured to...
March 23, 2006 at 7:35 pm
Didn't work.
I had a global variable populated with code called by a text box in the data region. It populated "Record x" in the variable and a call to that variable...
May 3, 2005 at 12:57 am
A simpler suggestion may be to replace the date parameter with a string parameter, pass that to the sql which would converting it with a CONVERT function.
In fact a...
April 27, 2005 at 1:30 am
Thanks for the reply. The VBS file appears to be pure object1 = <column1> and column2 = object1 kind of stuff, so its not a clear mapping...
October 31, 2003 at 9:40 pm
No that's not what I asked for.
I need a report of the COLUMN MAPPINGS in a DTS transformation, not all the columns in a table.
eg
Source Col ...
October 25, 2003 at 6:38 pm
That'll teach me to check things before posting ! 🙂 xp_sendmail quite happily sends to non-smtp addresses like address book names and distribution lists, so no problems there....
June 29, 2003 at 9:40 pm
One question on CDO and CDONTS - from what I see it has no built in facility to return queries in the message body, in the same way xp_mail...
June 29, 2003 at 6:06 pm
See my thread in this section about "Making xp_sendmail behave like Outlook." MSDN doesn't seem to have anything on @type, or IPM that ties in with what BOL says...
June 26, 2003 at 5:19 pm
Well, MSDN has a few topics in IPM, but nothing that elaborates on this IPM.Vendorclass.subclass structure, so I'm none the wiser as to how to use it in TSQL.
I'll probably...
June 26, 2003 at 5:13 pm
Can you be more specific as to where on MSDN? And do you mean the CD's or the www?
June 25, 2003 at 1:28 am
This command....
DBCC LOG (DBID/DBNAME, Type = 1/2/3/4)
...I can't seem to find it in BOL. What is the BOL topic if it exists, or is there any other...
June 9, 2003 at 6:01 pm
Thank you, that's a good tip to know,using profiler.
My question is, is there a simpler workaround to defrag blob extents that doesn't involve exporting data & dropping tables? Will...
May 13, 2003 at 8:58 pm
With respect to that MS support note about blob extents being fragmented, would it help to shrink in Ent Manager with the "Move pages to beginning of file" check-box...
May 12, 2003 at 6:20 pm
Thank you . That's a perfect solution.
I've only now become aware that the @attachments parameter in xp_sendmail allows you not only to specify an existing file...
November 28, 2002 at 8:35 pm
Worked OK for me so far, using this batch file
textcopy /Sserv1 /D "[cowden limited]" /Umwd /Psmeg /Tpl /Cbody_word /W"WHERE plkey = 'B0001' " /Franges.doc /II
...where body_word is an image...
November 6, 2002 at 11:34 pm
Viewing 15 posts - 1 through 15 (of 24 total)