close.  can i actually get the actual name of the backup file that has been applied?  for example, if apply a backup with name servce_20050714_0600_log.bak where will i get that...

i thought i need to upgrade my OS first before i can upgrade mg SS from standard to enterprise?  i think i read that somewhere.  coz if all i really need...

got it.

another question though.  what's the best way for me to backup my dts.  should i include the msdb in our regular backup?  coz, the way we're doing it at...

is pkzip25.exe a freeware?  i can't seem to find anything over the net.  all i got is a pkzip.exe and it does not handle long filenames.

ann

What if I use a long filename? 

Ann

i used the collate syntax and my query is working now. 

i was just thinking, although i havent tried it yet, is it possible to just edit the collation setting...

i am referring to page header/footer. hmmmmm, i never even thought of using an excel template where i will put the customized page header/footer then i will use that template...