ALZDBA (9/21/2009)

---

I noticed if you add builtin\administrators, it gets individual auth in every database, so...

Steve Jones - Editor (9/21/2009)

---

One thing I'd be concerned about is an app pointed at the wrong server. Are the db names the same as production?

I''m sure your trace will...

ALZDBA (9/21/2009)

---

- You shouldn't have switched them to simple recovery, before you have the answer to your question.

If you hadn't switched it to simple recovery, you might have been able...

First thing I looked at was default trace. Only see DBCC SQLPERF(LOGSPACE) and autogrow and autoshrink...

You could also take the OR's and do a union instead.

Select

From

table

Where

column between a and b AND

...

Lynn,

I did read your latest article and it was good. I usually only comment on the ones that have what I believe to be a bad practice in them...

Yup. It was using Profiler 2008 as well.

I think I've got one. I've asked 3 times now for an code or an example of what he is doing and haven't gotten anything. I can only...

Jack Corbett (9/17/2009)

---

If you shared the code in your trigger someone might be able to help you do what you need. What will be most difficult is that the...

Are there other indexes on the table which you did not include?

Yes the only options you have is to either change your columns to unicode or have the vendor use...

Quest as free tool as well called Quest Discovery Wizard for SQL Server.

My understanding is that SQL Server only reads and writes in 8KB pages so the number of reads would be the number of 8KB pages read into memory for the...

Yeah, I'd say it might be bug. It's definitely an interesting problem regardless.

Jack Corbett (9/17/2009)

---

There is not a way that I know of to do what this trigger does because this looks like it creates a trigger on the database that fires...

I don't have a link to documentation available, but yes this is allowed in the license agreement. Google for the SQL Server 2008 Licensing Guide and it is in...