Steve, I disagree about the smaller drives. Larger the better. Not because you want to fill them, just the opposite, you want to keep a lot of free space. I...

Sounds like your DTC isn't running.

Andy

Andy

Only if you control the data yourself. It's just like putting XML or a word doc in a blob - it's structured, but SQL doesn't know that. You could just...

Just a swag, I don't see how you could help it. SQL would have to pick up the entire page in order to read the rows to get the pieces...

I havent tried it, but Im pretty sure it's all stored in tables in msdb. Probably can just DTS the rows over. I'll see if there isnt any easier way...

Thats a good tip Brendan. There are some cases where the compiled query plan is good in one situation, bad in another - forcing the recompile ends up making it...

I would expect it to be faster - but like Steve, I don't use it often! Profiling is a good idea. How long does the report (the query or queries)...

I agree that using NT groups (AD or not) is a good way to hand off administration to someone who has the time. You'd still want to map the NT...

Sure. Just restore the backup, then detach!

Andy

Time bomb isnt bad, but depending on how skillfully done is sometimes easy to beat. Registry storage isn't bad, but again, it's easy to profile registry access and see where...

I've got several fairly specialized articles about replication posted. Other than reading BOL, I haven't seen anything really great about it. MS does have a few whitepapers. I recommend that...

Yes, it is possible. In SQL2k you can add/drop columns without a lot of work. In SQL 7 you have to do it the hard way! See if these articles...

I agree with Steve, reinstalling MDAC can't hurt, I'd apply the latest (2.6). In addition, you need to look at what statement is failing - do you get the same...

You will have to make the change manually. Easiest way is to drop the affected articles from the publication, make the change on both publisher and subscriber, then add the...

I think I saw this once, when something happened during the upgrade. I was in a hurry, so I just moved all the mdf's to a different folder, uninstalled then...