So you have the db definition in master, but nothing else? If DROP DATABASE doesn't work, then I'd allow system table updates, reconfigure with override and delete directly from sysdatabases.

Joe,

It's possible, but the main complaint with the digital world is the ease of stripping that stuff out. I think there still could be some type of advertising, but no...

Too short, yikes it took awhile to try and easily summarize things.

I'd love to delve in deeper, and maybe I will, but if anyone wants to dive into a specific...

Dan,

That's an interesting point of view. I hadn't considered the "tighter control" aspect. I think after watching programmers sneak too much stuff into production, I hate the idea of them...

It is an unsuported option, and one that is discouraged. However, there might be a time that you need it. Since you cannot do a single table restore, you might...

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.