awinter (12/1/2008)

---

1. After further review, it doesn't appear the deadlocks are coming from this process, but rather from some other ones. This process is the victim and...

Also, check to make sure that there are not duplicate DBmail profiles:

SELECT * From msdb.dbo.sysmail_profile

Hmm, I thought that SMTP used port 25?

Install and start the MS SMTP Server. I beleive that it is free and part of XP SP3.

Hmm, not sure abut Install paths, but here is what I use to find the Data directory for Master.mdf. I have added the folders Date Created also:

Create proc spFindMasterdataDirectory...

Hmm, guess I forgot that SMTP command line is not built into Windows.

Have you started SMTP services on your system?

Agreed.

Yeah, I don't think that Database Mail would work on Express Edition.

Can you communicate with gmail SMTP through SMTP command line?

Chris Quinn (12/1/2008)

---

Jeff Moden (12/1/2008)

---

My most sincere apologies... I was just cranking through some posts and didn't notice this was for MS...

This is an entirely different question and should be re-posted as a new thread, probably under "Working with Oracle".

What edition of SQL Server are you running?

Thats a good point, Jeff. I had not been thinking of VM differences.

Oops, you folks are right, my bad. That's what I get for posting at 2AM...

Well syntactically, you want something like this:

insert into tableA (column1, column2)

values(

(select column1 from tableB)

,(select column2 from tableC)

)

This is valid syntax, however, the logic of this looks pretty suspect.

Select Cast(ID as varchar(18)) + '-' + NAME

From YourTable