Kevin,

Thanks, but send a note to Andy and his team (awarren@sqlservercentral.com). They really made it work!

Actually I was surprised since it's a completely (insert inappropriatel anguage here) design. And they're supposed to be "smarter" than everyone else. I may be heading back to Yahoo now...

I'm sure that a majority of people at Choicepoint and the other agencys are concerned about the integrity and the safety of the information. But I'd also guess that it's...

1. Whoops, not sure how we got Sunday's question here

2. The BOL and the KB show that it's 256MB. Seems crazy, but on...

I never lock a record for more time than the transaction takes. It has constantly caused issues where I have had developers do it.

If the application crashes, you have an...

Most of you seem to be missing the point that EDITING takes place. You NEVER want to allow editing inside a transaction, so you would get the record and implment...

nice, that was funny. Glad you think that we're well respected , not sure everyone agrees, but we're glad there's a few.

I definitely...

Using a semaphore in C#/SQL or VB/SQL programming would usually equate to some flag on a record that it is being edited. Then the application is designed to respect the...

In what way?

Thanks for the comments and I'll work on refining my interview skills as well as doing a few more.

I'm of a similar opinion. I think much of what we use, should be, and is in many cases, a tool. A commodity. The closest analogy I can think of...

Try the dotnetnuke framework. Pretty complete, we use it for Database Daily and it's got lots of add ons.

http://www.dotnetnuke.com

Please contact the person in the post above if you are interested.

I agree that the server name in a linked server doesn't have to match, but it gets confusing quickly if it doesn't. It's one thing if you have 5 or...

I agree with Brian. You may be able to do some sort of repair, but likely there is corruption on that box. I might take it offline ASAP to be...