Are you asking about xp_sendmail? In SQL 2005.. While it still exists, let me be really clear.

DO NOT USE IT UNDER ANY CIRCUMSTANCES!

(climbing down off soapbox..)

It...

Perhaps you should spend some time working with some of the examples, maybe even see if there is some data at work that you might be able to work with,...

The indexing operation was largely a read operation, depending on the memory of your server and the size of the table it could have largely been in memory, which would...

Does the login that SQL is running under have access to that share/path/file? Or is SQL running as local system? If it is then it will NEVER be...

And you are sure that the sql server exe is using all the processor?

Depending on your server configuration and hardware, it is possible for even 1-2 connections to nearly monopolize...

Firewall on the server maybe? Check to see what ports it is listening on..

http://technet.microsoft.com/en-us/library/cc966526(printer).aspx

Says that the port it listens on by default is: 2383..

CEWII

it is a blank which can be test as fieldname = '' < that is 2 single quotes.

If you absolutely don't want that to happen you could add a check...

I can't see anything that is obviously wrong..

But given the error message I would look specifically at the connection: PCIDI1S and "Win Oasis"

Also you are using two different connection types...

Processor count and speed.

Memory available onn box and memory allocated to SQL.

Other applications installed on server.

Other databases on server.

Drives (local, iSCSI, SAN, NAS) and underlying structure (RAID5, etc.)

Layout, drive for...

Is this a one shot or something you will be doing a lot?

If it is a one shot then the best way is to generate a full backup and copy...

I think you could accomplish this using a rule in Outlook, it isn't NEARLY as easy as what you are trying to do this way, but I see your goal..

CEWII

I think I *might* see the problem.. default instances of SQL use port 1433, express usually doesn't without you doing something intentionally, this part of the connection "174.0.11.10,1433" is...

I can't stress how much I don't like replication, I do however realize that it does have its place. It sounds like log shipping is a better fit of...

SELECT * FROM msdb.dbo.sysmail_principalprofile

There is a column IsDefault..

You can get a list of profiles with sysmail_help_profile_sp.

CEWII

Following the execution of the raiserror sproc you should look at @@ERROR

It would look like this:

IF ( @@ERROR = 0 )

BEGIN

EXEC SPMy_wrapper_insert

END

CEWII