Calvin,

Thanks!  The query analyzer tools/options/results/ print column headers is a option in the gui. do you know of a way to control this via tsql?  I dont need the line...

Thanks so muc for the help!  I had tried something very similar to your suggestion, but must have had a typo?  Just couldn't get it to work!

As a follow up...

Ok.. I am not sure why this isn't working but maybe a second set of eyes?  I have tried multiple iterations..but here is one of them..

Bascially the select returns a...

Mike,

Thanks so much!!  This was a lifesaver..  I do have one other question.. the developers have apparently used the name enddate is numerous tables.. is there a way to search...

Thanks for all the help..   Does the system table map in the 2k res kit apply to 7 as well?  I am running a mix of servers.  The 7's are...

Thanks for all the help.... I was using the sp_delete_backuphistory, before writing here... The problem is the data is so old.. the msdb has got data from 2001, and 2002,...

can you give me some more details about how you trim the history?

Thanks

not to ask a dumb question but is he using the true ip of the server? rathe than a NAT address?  can he use enterprise manager or query analyzer ok?