Take advantage of more memory beyond the 2GB that's standard in the Windows kernel (32bit)

No offense taken. Just clarifying. I had to go back and reread the question after your post to make sure.

Remember to answer the question and not read beyond or try...

Actually we asked that a series of queries occur within a transaction. I guess we could have specified 3, but given the questions, the answer should be obvious if you...

Thanks for the complements and hopefully this will help some people.

David, you missed it slightly. Early in my career I had a 3 year time frame, looking to gain different...

, Godwin's Law certainly applies to Slasdot.

Don't think so. Might nest the IF's to make it slightly cleaner, or space it out better, but I think this is as good as it gets.

Good suggestion, I'll see if there's an easy way to build it.

Steve

To me they are putting a bigger burden on me. The feedback form is a mess.

First of all, I select a product and search. That alone makes it hard. For...

Interesting comments. I don't think there's anything wrong with MS writing a new OS, charging for it, etc. But I'd like to see them and other software vendors continue to...

Dan,

Thanks for the clarification and I'll try to be more understanding, but I think in the interest of trying to make it better you've taken a step back. Might be...

Not the first time

Do you have multiple instances? Or are you running smething else that could possibly use the SQL ports? Looks like a problem getting the port assigned to SQL Server from...

Not really looking, they just like the idea. Saw a 125 for sale around the corner, drooled slightly, but drove on. My kids are 13, 7, and 4. We had...

It's both good and bad. Centralized access means an easy change to disable an account, reset a pwd, etc.

It's bad because stolen credentials mean access to anything. Not unlike...

This could be done in T-SQL, but it will be a little cumbersome. YOur use of LEFT or SUBSTRING will get the first part. As to the remaining amounts, there...