Wayne,

Backing up all system dbs to one file actually makes some sense. You'd likely want all of these together in a DR situation. Thanks for that note.

It's good to know it runs Express, and thanks for your note. I might check one of these out as a good machine to carry around on a regular basis.

Yes, they could. In fact, there are data centers that require a handprint or retinal scan to access them. They store a biometric representation of you.

Jeff,

I agree, he's probably not going to get the job, and probably shouldn't, but given the people I've interviewed and talked with others about, maybe he will. Surprisingly how many...

OK, I'm really confused now. I was going to change the picture to a new shirt, but most people like the shirt.

Hmmmmm, I think I might redo the image,...

Thanks for the update and good information. I hadn't thought that the SP would improve performance (or lack of one ruin it), but that's a handy piece of information.

How are you editing it? Did you open it in BIDS? IF you did, only BIDS can then edit it.

If not, then you might have some corruption with the install....

The job is easy, you set up an operator and set notifications for completion or failure.

For the workstation, does someone kick this off? When it fails, meaning it stops running,...

The thing you want to check is if there are open transactions in there. That is usually what causes the log to grow crazy. Or if youhave an extremely large...

Are you scanning the mdf/ldf files with Symmantec? You should exclude all database files from scanning.

You can use any EM to do this and connect to an MSDE instance. The triggers are stored in the database, so a backup and restore will move those.

I didn't...

Moved to SSIS forums

Great job, and good advice for all types of DBAs.

The char column cannot be 9000 bytes. You define the char column. It can be up to 8000 bytes.

If you try to put more in, it is truncated.

Not that I ever got asked to come, but I wouldn't wear a tie to interview with you, David 😀

course, not sure I could pass The Quiz.