You are welcome, and if you wouldn't mind, can you show the code that worked for you?

Excellent, this should be an easy one.

Especially in SQL CLR. If you pass in the wrong types for conversions, you might end up with multiple conversions...

What you want to do is compare the inserted and deleted tables. If there is no change, then no insert. If there is a difference, then insert something

So if I...

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/

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...