As someone that has had to renew passport early a couple of times due to it filling up....

Flying is no fun anymore.  And no not because of the security...

That is indeed a bit strange.  Only thing I can think is that you have a higher precision on the underlying table and it is truncating some of those values...

From that dump looks to me like you have might have the /PAE enabled in boot.ini?  If so try removing that and see if that fixes it.

Thanks all. 

Most of my jobs in 12 years as a DBA has been either trough friends in the industry, so I knew the company, or I knew the company's...

LOL yeah the situation here is not ideal.  Obviously not going into much detail on a public forum....

The good thing is the first thing I did after getting SQL 2005...

Sorry took the weekend off completely!  (i.e. my home computer had a meltdown..)

I personally agree that it is better to be here to do it.  Or at least have some...

Yeah that was not literal, you have to get the datetime in there.  Not sure why you keep insisting on changing the SQL code directly instead of using the maintenance...

It would be easiest to use the Maintenance Plan, for the first solution it should be able to do everything I said . 

I run the deletion as the second...

There is a couple of diffrent ways to accomplish what I think you want.

The easiest would be to set up a maintenace plan that creates a new file every night,...

After doing 2 seperate road trips in the last two weeks, longest one was 1150 miles in 2.5 days (including watching races Saturday and Sunday....), I want an autopilot for...

Did you try to include the xp_cmdshell in the variable and then execute (@t) instead?

Was the backup on the tape saved directly to tape, or was it a SQL backup to disk then backed up to tape?  If the later you might have to...

I use the DDL triggers to capture any change it can to a table.  Every morning it sends me an email with the changes in the last 24 hours.  Then...

Sounds like the job for a new DBA. 

Or at least some training.

hmm thought that was what my code showed (conceptually).  Post sample of what you want it to look like after the split maybe I will understand better.