Exactly. Good practice is to us is null or is not null. Saves a lot of headaches.

Andy

Easiest way is to set up a generic log table, insert the proc name, a comment, etc, then have a job to email it or dump to text file or...

Definitely have to have a good reason for doing it in my opinion. Splitting out into separate/different data types means you give up all the date functions functionality. Hows that...

Havent seen this. I use Access2K, but not heavily. Did tons of work with Access 97, never saw that problem. Have you checked MSDN? Any chance the tables in question...

I leave both settings enabled. I do have a job that checks all dbs so that if any have the auto update turned off, it runs sp_updatestats once a week....

Im a fair touch typer. Worth learning I think. Lets me concentrate on the real task, not typing!

Andy

I dont see why you couldnt do it pretty easily using DMO. It's a COM object, so you could do it all in an ActiveX script, either inside DTS or...

Might try it too. Been thinking it would be nice to have Perfmon on a monitor on the wall or something, cycling through various servers so I can glance up...

Can you post DDL for the tables? Makes it a lot easier for us to work on!

Andy

If you're using ADO with a client side cursor it's going to pull every bit of that data to the client. Try switching to a server cursor. Beyond that, is...

Are you running an index rebuild or shrinking the db? Both generate huge numbers of transactions.

Andy

Please post in one area only - we check the topics daily, cross posting just makes it confusing for everyone.

Andy

Would depend on whether they submitted as a transaction or not I think. Been meaning to look at Access to see how it does this, maybe tomorrow should free time...

I'll have a follow up article in the next week or two that looks at what actually gets done by the plans.

Andy

I think the defaults work fine. You can easily change collation (well, as easily as it can ever be) in SQL2K, dont have to worry about a server wide setting...