thats great

thx

that was exactly what i needed

thx david

sorry - pressed 'post reply' by mistake

any how....

i have a table that looks somthing like this:

  Father          Son       

    AA              11

    AA              43

    AA              11

    AA              11  

    BB              22

    BB              11 

    BB              22

as seen the 2...

ill take that into consideration

thx

ill be doing evrything

but i think ill pay more attension in maintenance

because DB programming is almost the same in oracle and in sql 2000

the DB is almost static  - i add a record about once a week

so theres no chance to loose data

i can only take 1 of the 2

thx

its exactly what i was looking for 

thx

thx

which course should an oracle DBA take to be a sql server 2000 DBA.

taking into consideration that ill be the only 1 taking care of the DB

i dont get y microsoft makes it so easy to delete tables

any how

when i do a restore - cant i just restore the final transaction log file ??

( probably NO but...