If you use Execute As and the service account for SQL Agent, what comes back?

Please start a new thread if you have a new question.

gissah (3/16/2011)

---

WHERE (Type NOT IN ('Siu-ai', 'Subrogation', 'Siu-fi', 'SIU', 'Siu-mi')) AND (Company = 'xxx') AND ([Compliant Status] = 'xxxxx') AND

...

Also keep this in mind. If you do a large transaction, maybe a large update. You need log space for the update PLUS log space for the rollback. That's because...

Not too late. I'll send an email shortly.

Do you mean large in terms of the activity? Or is the log just large all the time? Do you have log backups running?

The log writes down records based on...

Please show some sample data and explain what you are trying to do. Your explanation of what you need and what is happening is lacking details. Write more information about...

We do not have that. We have talked about it, but it's a double edged sword. what you get to work, and think is a good answer may not be...

Does this return something?

select open

from view_rpt

where open = 'null'

I suspect that application might be storing 'NULL' and not NULL.

Scott Arendt (3/16/2011)

---

ronmoses (3/16/2011)

---

The nearly 40% of respondents who got it wrong learned something today. That alone seems valuable...

The select works for me, inside and outside of master.

Not sure what's wrong for you.

Nice job, Gail, and I didn't think you insulted Robert. I think sometimes they are asking to learn something (they don't know everything) and sometimes just giving you a hard...

I'll run the draft tomorrow, sending emails to everyone and asking for picks. You'll have to trust me to draw the numbers here for ordering.

If we don't get more, we'll...

Please show the query, table DDL and sample data

I also don't see the point in not offering downloads. Not like it couldn't require a login or a page view to get them.

The Windows Media streaming sucks. Never seems...