Log in with the account used to run SQL Server (the service account). Run outlook and check the profile, be sure it can send and receive. Likely something is misconfigured...

You can break up the insert as well, use a transaction if needed, and insert in batches rather than one large statement. That could help with memory.

Interesting.

BTW, Clipper uses dBase format, so you can use those drivers.

Brandie,

What's your trigger code? Are you rolling things back?

They should work no matter what. A sysadmin doesn't override the trigger. Can you add log code to the trigger to see...

I realized that and had to recheck the question, but I don't think it implies space on the drive. The log could fill up, with no autogrow, and there still...

It definitely wasn't me and no sheep on this ranch. I was actually in Mexico, swimming with my daughter, completely unwired and enjoying the day.

I've fixed the ID, though I...

We definitely can't test the scripts. Barely enough time to get the editorials, QODs, etc. Even if we did test them, we wouldn't be able to test them exhaustively.

We are...

No moderators on the site. The volume was too heavy to let someone be responsible for looking at them.

That is a good idea...

Yelena,

A truncation actually does free up space inside the log file to be used again. It does not free up space on the drive.

Jeff that is cool and I'm glad to be back.

And I'm not that thrilled with the tractor or mower as a "gadget". They're more tools, requiring me to do work....

Actually while he's the person that's doing well at Sun, I think he's the type of person that Microsoft needs. I'm not sure Steve Ballmer is that person and with...

What happens? check the Windows and SQL logs when it fails.

This:

create table MyTable (roomtype varchar(4), amenity int)

go

insert MyTable select 'R001', 1

insert MyTable select 'R001', 2

insert MyTable select 'R001', 3

insert MyTable select 'R002', 1

insert MyTable select 'R002', 2

insert MyTable select 'R002',...

What does the job do? What does datapump task 1 do?

Shrinking is bad.

Paul Randal, PM for the storage engine, says you should never shrink the data file unless you think you'll NEVER need the space.

http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx