Heck, I'll throw out the "O" word here.

You might even want to look at Oracle 10G grid computing. It may be a better...

How about a

select * 
into history_log_temp
where event_date > '1/8/05'
go
TRUNCATE TABLE history_log
GO
INSERT INTO history_log
SELECT * 
FROM history_log_temp
GO
DROP TABLE history_log_temp
GO

Just my $0.02.

The DIR /X only gives you the short name of the files/directories in that directory. My method automatically translates the whole prompt for you.

I agree the preference is not to...

I agree:

Clustering does not improve data performance, though, I thought. I was under the impression it's a logical choice for high-availabilty, not necessarily performance tuning.

But if he is looking at...

My suggestion is a big honkin server!

Performance is dependent on multiple factors:

CPU, Memory, disk speed, transactions, indexes, how data is added, number of...

The easiest method is to go back to the 8.3 dos format for the path. A quick way to find out is from a cmd prompt

cd "C:\Program Files\Microsoft SQL...

First of all: I suggest that you make good copies of everything somewhere else. It may take several iterations to recover.

You can try creating a blank database with the same...

It shouldn't.

I would see if there was a way to back up the system before conversion. I've converted over several systems to NTFS without a problem.

http://www.ntfs.com/quest3.htm

http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/convertfat.mspx

http://www.tweakxp.com/tweak264.aspx

Try it without the "TO FILEGROUP PRIMARY"

And if you haven't converted to NTFS then the initial and max sizes need to be below 4GB.

  SIZE = 5GB,
 MAXSIZE =...

Assumming you are using Mixed Mode authentication.....

When you re-created the user ID are you sure that the user ID has permission to the database?

I actually ran into this recently. Our DR server ($#$^#$ POS ) died the Friday before DR testing, so I grabbed our test...

Also check the file growth properties on your tempdb.

The SQLSERVERAGENT is the dependent service.

I would suggest that you try going under the services applet on the control panel and try firing from there.

While you're in there check what...

Try this -

1 X Pentium 100MHz, 128MB RAM, 10GB & 4GB HD, Win98SE.

I haven't fired it up in a month and it was 3 months before that.

I spend so...

I don't think you can really do it as replication. I believe you would have to do it as a DTS (Data Transformation) task.

You will need to have the...