Thanks. basically I need to match SS from the excel to the employee master table. if no find, then append them,  I want to auto the process.

I use asp.net and vb.net to develop application, too. I am thinking about get to expose to dba role, too.

I always use vb.city first before I use google.

Why not put the content of your text file into the message body directly ?

Here is another link for explaination

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=245636

I talked to our exchange adm.

Here is his answer.

An smtp server has to be setup somewhere. And also need a valid email...

I did not get any error from the sql server. But my email inbox receive the following error message.

Thanks.

From: postmaster@DBASE-SVR.hot.local

[mailto:postmaster@DBASE-SVR.hot.local]

Sent: Saturday, December 17, 2005 12:43 PM

To:

I did not get any error from the sql server. But my email inbox receive the following error message.

Thanks.

From: postmaster@DBASE-SVR.hot.local

[mailto:postmaster@DBASE-SVR.hot.local]

Sent: Saturday, December 17, 2005 12:43 PM

To:

job just some automatically email the count to some one. (query result). I can start the job but just did not automatically right now.

Whenever the end user access the webpage. the asp add the record to the database. I just need to run the stored procedure to get the previous month count from...

I do not know. I checked the application event log. It just gave me  a error without any message. I run the email stored procedure(which have nested stored procedure in the query analayer ,...

You need to look at your C# parameter set up. It was confused while I used that.

CREATE PROCEDURE get_DVCount

as

return  (SELECT COUNT(*) AS CountOfDV  from [Module Log]  WHERE [Access Module Time] >= DATEADD(m,-1,DATEADD(m,DATEDIFF(m,0,GETDATE()),0)) AND [Access Module Time] < DATEADD(m,DATEDIFF(m,0,GETDATE()),0) GROUP BY [Module Name]

HAVING     ([Module Name] = 'Domestic...