I took your code ran it on my server and it work as expected

I got one row back?

Scott

MSSQL query engine can not parse it correctly and column name can not have spaces in them. Rpt.fullname as Member Name this look like...

Just to clear up some thing

camiloaguilar1 (11/17/2010)

---

I just check my table, and I can't use min() because there is a value greater and I have others less.

And I can use...

Try this it should work

SELECT DISTINCT

Rpt.fullname as [Member Name]

,Rpt.memid as [Member ID]

,e.orgeffdate as [Org Effec]

...

Hi Paul

You have to run that in the same transaction as the INSERT statement that loads the data.

The only other change was to run the tests on a database...

I am sorry to say that I do not us SSIS that much, all of my ETL work is done with a product from Pervasive called cosmos

I know that SSIS...

Paul

First off, Thank you for all your help and time you spent on this.

I now have a greater understanding of how this works and what type of logging is

going...

Hi

You could create a SSIS package that you can schedule to run when needed

Scott

Paul White NZ (11/14/2010)

---

In the meantime, I knocked together a demo based on your example, which shows TF610 working as advertised:

Here is the result to your script run on my...

Hi Paul

Here is some of the info you asked for As you can see for the log size and it is acting as it is fully log

As before

Thanks for...

Jeff Moden (11/14/2010)

---

Heh... OK... Now I get to pry the shoe out of my mouth. :blush: It looks like TF 610 does, in fact, help with converting fully...

Thanks for the time I will pull the plan for you and test your script in my environment

Scott

Hi

I am not saying that Sunils blog is incorrect but in real world testing it not working w/t610 on and with TABLOCKX or with out TABLOCKX.

Scott