yeah sorry..

windows 2003 std

sql 2000 std

cheers

Dave

bah.. sorry, i've stuck this into the wrong group..

Dear admin, please could you move this post into backup / scripting section.. ta

here is the final code i went with, its works perfectly! many thanks for your help..

declare

@UseDate as varchar(50),

@dbname as varchar(50),

@mycommand as varchar(2000),

@fromdisk as varchar(500),

@frommoves1 as varchar(500),

@frommoves2 as varchar(500),

@frommoves3 as varchar(500)

set...

many thanks both, I'm just going through and re-building the string.

i'll let you know and post a finished sample when its done

many thanks for your help.

dave