Ok all you C# MVPs and pseudo MVPs...

How would you store a bitarray in sql server, in the most compact way possible?

1. What sql server data type?
2. How would you get the BitArray into that datatype and out?

I was thinking I could just do a ToString() whould would give me a hexadecimal representation of the bits, but it just returns System.Collections.BitArray. Argh!!

I'm assuming I can store 8000 bits in 1000 bytes? Yes/No? Can I do better?

HELP!!!

Thanks,
BOb