I many have come across a script that does the trick. So far so go. Will have to insert into the application and test.

select

sys.objects.name name,

sys.objects.object_id,

sys.objects.create_date created,

table_description...

Thank you for the reply!

yes, I added in distinct and saw that it would remove the repeating values. I'm just concerned why the value repeat in the first place....

cool trick, I'll give it try. Thanks for the replies>

so if I understan, you are suggesting adding an identiklty column. This way I can address a row via a unique value. Yes?

Yes, I would like to update the 'Null' value to the previous non 'Null' value

opps I wrote that backwards.  the Data files arrives first then the trigger..

I did verify that with the sender and confirmed via the ftp log that the trigger arrives first and then the data file. 

Log shows -- user come in ..creates...

My server admin has verified that no system maintenace jobs are running during this time frame.   He has also checked to see that no one is logged on the box...

The schedule has two steps:

1) check that a  trigger file was sent. This is nothing more then a trigger.txt and contains a comment "this is a trigger file".  It is sent...

Quite true.  Rule of programming is to try it for yourself.

Supermodel to sql is an interesting transition. 

Each is full of glamour and high living.

parties, booze, sex.....  and end users...

Yes, I will always admit when I am wrong.  My apologies.

However, a previous post indicated that the level setting was not the issue.  This was alos stated by one of...

Thats it.  I adjusted the comp level and its working.

Now this opens the disscusion of what are the potential gottcha's.

No its a good catch.  I was under the impression that service pack 3a had been applied during a recent server upgrade project.  Turns out that because my then server...

Hmmm I was under the impression that the service packs had been installed.

Thanks for pointing that out.  I think the datacenter has some explaining to do!

yep order by works just fine.