What other rights? Perhaps something that deny's access?

Not sure of the issue, but it looks like the package might have issues. If this is a maintenance plan, I'd recreate it. Simple enough to do. Can you open...

The MDF file is the database. You wouldn't zip up this file, you'd zip up the backup if you want to move it to another system. A backup is the...

It's easy to say I want to do this, but think about the times where you have an issue. What if you get halfway through and power dies? You could...

I have not seen issues reported with any CUs lately, but I would caution you that these are not heavily tested. If you don't have an issue specifically with one...

The file formats are the same, so you can do this. However if you have features that you are using in the primary that aren't supported on the secondary, some...

I tend to agree with Gail's approach. Don't update everything if you don't need to.

There's a counter to keep track of # of rows changed. Lowell's script seems to make...

I haven't really seen any issues reported with SP3. The new system seems to be working well. I expect an SP4 before too much longer.

I think I'm winning, but my back and knee might disagree.

I'll blog the whole thing later. It's a good project, and easy to do if you don't mind a little...

Lost thur to errands and my wife's truck tires, but I need to cut 6 small trim pieces for the edges along the wall and then glue about 12 tiles...

Michael has a good point. A basic SQL setup ought to be like the car. Which means that on setup for the incidental DBA, there either should be some notes,...

It varies by version, but first, you need to clear the log out.

The basic steps are to clear the log of active transactions, then shrink it, and then set...

Are they completely duplicate? All fields? Be sure you keep the one you want if there are differences. Mark's solution should work, but it's not checking which row might get...

agreed.

I'm not sure we pay too much. There is some competition, and there's certainly demand. I wonder how things would work if we could al la carte things.

I'll tell...