thanks very much your a star

you missed the begin at the start and extra quotes around isreadonly....other than that your forgiven

Thanks so much

L

doesnt work in 2000 as it doesnt know of a coloumn Is_Read_Only in sysdatabases

i noticed that you left the system db's out but i'll probably include them as this is...

thanks for the reply

but....yep theres always a but

how can i get the dbcc command to cycle through all the db's and miss out any that are set to read only...

Thanks Guys,

tosscrosby - your script is not parsing correctly so havent been able to test.

oracle - this is not really what im looking for

i need to report on just...