Rebuilding your db is a huge amount of work, lots of stuff getting moved around in the mdf. Not much you can do about the log file size. That's why...

Here is the link:

http://msdn.microsoft.com/msdnmag/issues/1000/Stateless/Stateless.asp

Andy

I think there was an article in MSDN Mag last year about it - Johnny Papa wrote it I think.

Whether or not you apply true db standards I guess depends...

I don't see anything wrong with putting in the db. What structure you use will depend on your needs. If a flat table will do it, why not? If you...

Agree that absolutes are bad. Some are worse than others though.

Andy

I think you need to trap it in CF. That's how it's done in VB anyway.

Andy

Attach works well. It automatically upgrades the structure of the mdf to the SQL2K format when you attach, so you can't move it back to SQL7 later by detaching again.

Andy

Yes.

Andy

Not that I've had. If anything its a good setup, since you'll be testing with less horsepower than you'll have in production. If it runs ok on your development box...

Probably the best you can do is just set up a table that parallels sysobjects - if you use the same objectID then you can enter a comment for anything,...

20k is a lot. It would be a good sized XML doc and XML docs aren't small to start with. Shouldnt be too bad if just an int and you...

I'd say that's a fair point. But how much does it really cost? One thing I teach is to build as much data integrity into the table as you can....

Parameters is the usual approach. Not a great one, but it works. OpenXML offers some great alternatives, you can send over the equivalent of a shaped recordset (or a plain...

Maybe that's a more correct way of putting it, but does it really make a difference? Sometimes it IS helpful to explain things the right way, sometimes the result is...

Thanks for the feedback. UDL's are handy, not just for DTS packages. Every little bit helps later on.

Andy