Thanks for chiming in, Malcolm. I'd seen that post too, and planned to manually add the SP if need be, BUT... since I've run the instcat script many times...

We have a real mixed bag of SQL servers and I've run into this issue a number of time when linking various servers. Running the instcat script as described...

Thanks for those two very valid points, Yelena.

We have already explored your recommended method and the sheer size of that undertaking (70+ databases, some with as many as 1,400 tables) sent us...

Chris- Thanks for the advice, and for keying in on my base question.  I've also done upgrades from 7 to 2000 by backing up and restoring onto another machine and...

Heh.  Believe it or not, this box is only two years old.  The primary application it was serving as backend for was not supported with a SQL 2000 database so I...

Naaah.  I'll load it in due time (and probably sooner than I'd like in production if my boss has his way), but for now, I wanna sleep nights:-)

Hi Chris,

My first goal is to change the default settings for all new databases that will be created on this server.  A worthwhile secondary goal would be to change the settings...