[thelist] 8k Row limits must Go!

Anthony Baratta Anthony at Baratta.com
Wed Jul 10 15:11:01 CDT 2002

At 12:48 PM 7/10/2002, Rob Smith wrote:

>How do I increase the row size in a MS SQL Server 7/2000 database beyond 8k?


e.g. you can't without MS changing MS SQL to support it.

<TIP Author="Anthony Baratta" Subject="Recycling Hard Drives with Win2K">

If you are going to plug in a new but previously used hard drive into a
Win2K box and you don't care about the data - make sure you fdisk via DOS
it first. If the drive was previously a boot/system disk for NT or Win2K,
the OS will recognize it as such and helpfully prevent you from doing
*anything* to the hard drive.

In fact, after physically removing the drive you will not be able to remove
the "ghosted" reference to the drive via Drive Manager!!

To fdisk the recycled drive: plug the drive into a PC, boot with a Win98
floppy, and run fdisk.

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list