In that case, I recommend keeping a log of databases that are detached and when it was done.

These methods will find a detached file, but they don't take into account...

Uninstall-reinstall. Had one like that last year and that's what I had to do.

Someone asking for help here. I'm interested in other people's takes on it.

Is there a reason you need to consolidate it all into one column and make it into a custom code?

Why not have an int UserID column, a smalldate DateAndTime column,...

Database/Server Optimization

Training

Documentation

Training

Business Continuity/Disaster Recovery establishment, testing and documentation

Training

Detailed, in-depth system analysis

Training

System Clean-up (are there procs that aren't in use, files that aren't in use, etc.)

Training

That would be my main list.

After...

Yeah. I was just using it as...

Not sure what you mean. I just...

ubernoob (6/15/2009)

---

Grant Fritchey (6/15/2009)

---

ubernoob (6/14/2009)

---

Sorry for my quoted post above everyone. It was Grant Fritchey that posted under Steve's account and made the false accusations about my e-mail being...

talltop (6/15/2009)

---

I've worked for incompetent managers in the past as well and they usually end doing themselves in. They don't need my help. However, tellling off a manager or advising...

You're welcome.

talltop (6/12/2009)

---

The problem states that the manager did not want the files moved to another directory and the prior DBA honored that. However, I would have done the same as...

If they do what I do, and just open a connection and start typing, it won't help with that either. That's why I suggested code-review.

After reading that article, it also looks to me like you might want to take a look at the SoundEx and Difference functions in BOL. They might simplify what...

It is possible. Looks like what you'd need to do is take that function, and use it in a Cross Apply against the table and the input parameter (user-provided...

Jeff Moden (6/12/2009)

---

Heh... I...