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...

Interesting you've never used it. I use this as a first glance when I get a complaint about a new server. It's a thumb-sketch to see if this is grossly...

Moved to SQL 2000 forum.

what is the issue you are having or are you just looking for information?

XP supports encryption, but it's a CPU cycle issue from what I've read. I haven't tried one, but perhaps enough complaining will get my boss to buy one 🙂 for...

well said, Major. It's the "what" it says that causes so much debate.

apparently it's a hot button issue, however since this thread is one of the most posted to in...

Feel free to pass it along. I know there are lots of virtualization questions out there.

You can right click the SQL Agent and script out a bunch of this stuff as well. Packages you have to move manually.

I have seen issues installing SP3 from some people, but I haven't seen anyone report issues with the server.

no, these are specific to each instance.

Are the server and client on different SP levels.