it works

thx

thanks for the good advice

ill build one table with a clustered index on exercise number

thx

and i need it because i want the changes from 1 trigger to another to be as minimal as possible

thx

i thought is was to good to be true

i gess i will write the trigger...

as i understand it - in sql2000 onwindows - only sysadmin can use xp_cmdshell

thx

ure right about the privilegesin using the xp_cmdshell

im not a sysadmin - and i well never be

so what kind of role do i have to get to use xp_cmdshell ??

yes ure write - there was no backup

but the thing is - that even after backup - the log was still big ( no truncate )

only after i used the...

because i am working with an old program that reads only txt files

so if i want the old program to be up to date - ive got to use a...

ive just finished a sql 2005 convetion

and ure right - 2005 and 2000 are not so Similar

thats what i think - i should be able to operate the DB in case of crash - and the db is small right now - so theres no performance...

programming it is then

fantastic

that was great

thx

thx - thats even better