Viewing 15 posts - 31,936 through 31,950 (of 39,749 total)
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...
June 19, 2007 at 8:22 am
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.
June 19, 2007 at 8:21 am
Interesting.
BTW, Clipper uses dBase format, so you can use those drivers.
June 19, 2007 at 8:20 am
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...
June 19, 2007 at 8:19 am
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...
June 19, 2007 at 7:25 am
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...
June 18, 2007 at 11:40 am
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...
June 18, 2007 at 10:02 am
No moderators on the site. The volume was too heavy to let someone be responsible for looking at them. ![]()
That is a good idea...
June 18, 2007 at 9:59 am
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.
June 18, 2007 at 9:57 am
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....
June 18, 2007 at 9:41 am
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...
June 18, 2007 at 8:18 am
What happens? check the Windows and SQL logs when it fails.
June 8, 2007 at 10:04 am
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',...
June 8, 2007 at 10:04 am
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
June 8, 2007 at 9:56 am
Viewing 15 posts - 31,936 through 31,950 (of 39,749 total)