Wayne and Jeff have my ideas. Each error log's timestamp has the time SQL restarted, but if you restart too many times, you lose that data.

The event log is the...

Don't run repair allow data loss.

http://www.sqlskills.com/BLOGS/PAUL/category/DBCC.aspx#p7

http://www.sqlskills.com/blogs/paul/post/Corruption-Last-resorts-that-people-try-first.aspx

If the t-log is gone, then you can't recover past your last log backup. If the disk with the t-log crashed, but the data...

I think what you've have to do is add a new filegroup and new files, then rebuild clustered indexes for some tables on that new filegroup to move the data.

Once...

I've never seen that, but it's valid. I don't like it, but I agree with Paul that it's likely just convention

Since this is the water cooler, any comments?

http://abcnews.go.com/US/ground-mosque-plan-stirs-controversy/story?id=10670631

Playing Devil's Advocate, the problems with capitalism come with monopolies that can be just as much of a problem as a socialist government.

I think we have a pretty good balance...

SQLPing seems to be the most popular.

In the past, I've used Jeff's method, actually through SMS to query the registry of all hosts on the domain for a SQL Server...

You'll have to provide more information for us to understand, and perhaps ask a question.

Stefan's updates have been published for the article.

majorbloodnock (8/3/2010)

---

I agree with what you've said, but think you've missed one vital point. All the suggestions you've made are good tactics to have at your disposal, but knowing which...

Bug, crappy programming and testing.

Yeah, that's an issue. Best I can do is have you link to a search for the script.

In case anyone needs a humorous break: http://www.youtube.com/watch?v=KiFKm6l5-vE

Do not ever, ever, ever drop a database without a backup. Even if it's development. Take a backup, store it somewhere, at least for a few months.

Well the Rockies are doing slightly better.

However I'm not. Played a double header yesterday, 1-5, BB. My season is going downhill.