Ok, but what do you mean for "clear that table" ??

I have tried with

delete * from SurveyResults

but i get an error .

Thanks in advance

Stefano

so it means that everytime i want to change the poll, i have to delete the survey module from the page and create a new one?

its there any other way?

IM sure this is unsupported but...

1. Find the ID of your survey.
2. Make sure no profile has a length of over 8000  If so you would need to write code to do this....
3. Backup your dontnetnuke database
4. Backup your dotnetnuke database
5. Backup your backup

IN this case my survey is  460

Find the key in Profile that looks like ' tem key="460:Voted" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"><boolean>true</boolean></item>'

*****************then adjust the following queries  ****************************

update Profile

set ProfileData = replace(convert(varchar(8000),ProfileData),'<item key="460:Voted" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"><boolean>true</boolean></item>','')