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.

And I just got an email from a neighbor that there have been thefts in the neighborhood.

Yikes!

You could grab the prefix like this

case

when substring( namefield, 1, charindex(' ', namefield) = 'Mr'

then prefix = 'Mr'

when substring( namefield, 1, charindex(' ', namefield) =...

changed the answer to say decimal points. That should avoid confusion.

I'm not sure there are great regulations in this area. Legal requirements and limits usually lag far behind the technology.

An AP uses a chip to do encryption, and arguably not that well. I don't know how to judge it, but it encrypts network traffic. Netbooks probably handle VPNs, not...

Demeanor is definitely a part of that trust and I'll grant you that appearance is part of that. Without a doubt it is, but to what degree?

I think it depends...