User Profile

nilesh tayde · Jan 13 '11, 12:57 PM

Hi every body
I want to send a simple HTML mail using DATABASE MAIL feature in SQL SERVER 2005.

I've defined a public profile.
I've enabled Database Mail stored procedures through the Surface Area Configuration .
but I can't send a mail with sp_send_dbmail stored procedure in 'msdb' database .

when I execute sp_send_dbmail in the Managment Studio the message is
"Mail queued" ...

nilesh tayde · Aug 26 '10, 09:44 AM

how can i pass parameter to print access report by giving parameter as Report File Name,Query,Prin terName,Number of copies to be print

my code is

Code:

Function fPrintRemoteReport(strMDB As String, _
                                        strReport As String, _
                                        rptPrinter As String, _
                                        numCopies As Integer,

...

nilesh tayde · Aug 6 '10, 11:07 AM

Hi all

i want to write same data in single text file multiple times using this code. for singel time it work fine.

Code:

Dim lngRet As Long
    On Error GoTo fWriteRemoteReport_Err
    '''''''''
    'create a CSW in text file name
        cswFilename = CStr(Format(Now, "mmddyyhhmmss"))
        cswFilename = modInitialize.OrderInputFileLocation & "\CSW_"

...

nilesh tayde · Jul 21 '10, 03:50 PM

my csv contain had different datatype f.ex. in cell E8 data format is date, and other data in this E column are string.
i use this connetion string in classic asp and back end SQl server

ChekCnn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & Path1 & ";Extended Properties=""te xt;HDR=YES;IMEX =1;FMT=Delimite d"""
Set rs1 = ChekCnn.Execute ("SELECT * FROM ["&...

User Profile

Profile Sidebar

send mail through sp_send_dbmail in sql 2005

using .Docmd. and parameter as number of copy,file name,query to access report

write same data in multiple time in same text file

csv column contain mix datatype connot read all cell data using oledb provider