the following post

http://www.sqlservercentral.com/Forums/Topic529146-146-1.aspx

has a detailed answer from Gail for a similar scenario

and this post

http://www.sqlservercentral.com/Forums/Topic622415-146-1.aspx

has my previous answer

why act like a couple of little girls. The solution you provided is correct if the question were different. As far as i can see he wanted to know what...

the sql server simply connects to exchange over port 25 and sends the mail!

from your sql server, telnet to port 25 on the exchange box, do you get a successful...

what ADI posted is not what the OP required

do you have database mail configured correctly?

check BOL for more info

Paresh Prajapati (12/23/2008)

---

Can u differentate Active/Passive and Active/Active.

Bac i don't have deep knowledge and confuse to it.

I simply know that in Active/Passive alustering one is active at a...

certainly will

check this link

http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

scroll down and find the MSI package

better than a pork chop 😀

try manually installing the backward compatibilty tools from the CD.

the query optimiser will add an entry if it finds...

disable any constraints,etc and rename the table. Create the new table with the column order and then pump the data across. But why, as pointed out already it doesnt matter...

wow, as big as that 😀

not advisable

use the generate scripts option to script of the indexes, constraints, triggers,etc