Thanks Steve, that article hit it right.

Use the SQL Task function.

You can put any SQL in there

Consider using a linked server, and some TSQL code rather than DTS. Not that DTS is bad, I too am only good with DTS.

But I do this on several tables,...

Query Analyzer --> Tools --> Options --> Results --> Maximum Characters per Column.

It's probably correct, it's just truncating the 1 colimn result at 256 Characters !!!!!!

SQL Server would be an access method, if you create a DB, and want to read it with Access, VB or ... you need something to manage it.  Maybe DBMS would a...

Yes, you can create DBs and distribute the DB.

But you still need an access method, ie JET, or MSDE.

MSDE is poorly named (or acroynm'd). It is the Desktop Engine, basically a replacement for the old Access / Jet setup where you built an application with VB or ??...

You might consider adding constantly, then purge once a day (or more often ??), try and identify a quite time. Then come up with a purge routine.

Without trying it, I would...

I agree with SQLBill.

An automated procedure would have to deal with contraints (RI) issues.

Although someone here wrote something like this, he was not a good coder, an even worse DBA,...

I understand your question, can't figure out why you you want this.

But rather than dealing with "Out of Space" the overhead doing what you are explaining would be ridiculous.  And...

All of the above are true.

But I tend to do Indexdefrags / CheckDB etc AFTER a backup.

That way just in case anything happens during the Check or defrag, I have...

Well OS Defragging helps, if nothing else to consolidate some freespace into bigger chunks.  I have a 50 gig drive with about 20 gig free.  The largest contigous freespace is...

Anyone else out there correct me if I'm wrong.

Julian, I think you misunderstand the way a Clustered index works.  During an index reorg, or build you may be correct.

During an...

Some general checking I did a while back, not scientific but representative, I saw no real difference.

Keep in mind the "Where" style Joins are NOT ANSI compliant, could be dropped...

I don't remember the specifics, but SQL will put the fields out how it wants them.

I know Fixed fields are first, followed by Var..., and there is something special about...