Hey, congrats from me too, Lynn! ...

Also, a UNC working directory setting will only affect relative paths. It's won't affect any hard-coded paths with Drive letters or their own UNC paths in them.

You should probably try turning on logging to see what it is doing, and what it is seeing.

Attaching the database can definitely be done from SMO. A SQL instance, however, requires an install, AFAIK. Can't be done just from SMO.

Your send mail task should have an SMTP connection manager associated with it (SmtpConnection property). Open that connection manager to check its settings:

- SMTP server:

- Use windows authentication

- Enable...

martin.edward (5/26/2009)

---

Hello,

What am trying to do is copy data from table A to another table B, all new data from the table A should be copied to table...

Glad I could help! 🙂

Here's your problem:

ALTER proc [dbo].[VolunteerEventRegistrationEmail]

as

declare @last_id_sent int

DECLARE @sql varchar(2000)

DECLARE @File varchar(1000)

select @last_id_sent = max(last_id_sent) from WebTeamWebsitesData.dbo.tbl_2009_email

SET @sql = 'SET NOCOUNT ON SELECT *

FROM WebTeamWebsitesData.dbo.tbl_2009

WHERE id >...

You can change it's working directory, but it will still be executing wherever the DTexec is running. There's no simple fix for that.

Phil's suggestion is well taken, I always...

Actually I think you're...

CDR = "Call Data Record"

I used to work in that field too... 🙂

What is the problem?

You can just change it. You should make sure that no one else is in it (put it in single user mode first) just to insure that nothing freaky...

Well, you do seem to be correct about this and I will note it on my earlier post.

Nonetheless, the article that you point to also clearly indicates that a lowered...

You're asking two different questions here. First "how to run a query every 5 minutes?" Answer: put the query in a stored procedure, then write a SQL Agent...