Don Bricker-331219 (10/31/2011)

---

Thank you Gail and Ninja. I queried the trace file for the database in question and none of the events had the same timestamp as what I was...

Why do you need it to be as fast as possible?

Steve Jones - SSC Editor (10/31/2011)

---

Congrats, Gail.

I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think that...

opc.three (10/31/2011)

---

You saved yourself the headache...

sqlfriends (10/31/2011)

---

Thanks all.

First, I see the script is so long, I will have to study it a little bit later before I use it .

Second, I checked in the maintenance...

GilaMonster (10/31/2011)

---

Bear in mind that not much is traced, DDL,...

Tx Gail, 100 MB is still a tiny trace on a busy server... but it's better than 25 mb :hehe:

Banana-823045 (10/31/2011)

---

I wonder if I'm missing something when people say they don't like having 1000 logins.

While opc.three made good point about concurrent users (thanks!), I'm thinking it's not that big...

Was he trying to see if it was still in use?

If so you can just put it on autoclose and search for those events in the default trace. ...

It's not impossible that this may be in the default trace (you could check with a quick offline, online on a test DB. That way you're sure that if...

Yes but...

Chad Crawford (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Ninja's_RGR'us (10/31/2011)

---

WayneS (10/31/2011)

---

Just browse to the SSRS web page....

EdA ROC (10/31/2011)

---

Yes, RAID Drives - What I meant by safeguard is that it's a level of protection above a single drive system. Hence, like a physical safeguard device with...

Actually there's an easy way out of this.

Maint. Plans always reindex everything no matter what (needed or not). This is usually a big waste of time and ressources.

I use...

Encryption is also easy to undo if you were hoping to go down that road.

I've researched this in the past and aside from self hosting I couldn't find anything "easy".