Showing posts with label save. Show all posts
Showing posts with label save. Show all posts

Friday, February 24, 2012

Alt+X doesent work! argghhh..

must have done something magical in QA, cant run my statements..going mad...when pressing f5 or alt+x i get this f****ng save results box..have tried everything, not even the so trustworthy restart helped..
help!?What about [CTRL]+E...

It's got to be a setting, though I can't find it...

Are you on a client?

Maybe a reinstall....|||Check in the options under the results tab. Make sure you are not funneling output to a file.|||Press Ctrl+D & then use Alt+X

Thursday, February 9, 2012

All data has been changed to gobbledygook in my DB

Hello


I got a serious problem about my data in SQL 2005. I save data in SQL in Farsi, this is not English so. Up to now everything was going well.

But today, surprisingly, I found out all my data in database has been changed to some gobbledygook like these: ù??§ù??§????or?3?±???1 ?±?§ù? ?±ù??aù?

Although all data which I saved yesterday are correct, all the data for the past days has been changed to meaningless ones.

Anybody knows why n how to repair?

All responses appreciated.

Refer to the SQL 2005 books online for UNICODE data and ensure collation has been set to correct values.|||Hello
Thank you for your response
I told you that some of my data has been changed to meaningless data, while some data has not been touched. however I tested your suggestion but that was not successful.
any idea?
Thanks|||

If you are confident that you have not modified the data, and that the client is displaying the data in the proper code page..

Start by running DBCC CHECKDB if there is any damage in the database this should pick it up.

|||In The Name of God
hi,
Special thnaks for your response,
I restored my db from the backups which I had taken earlier and I had forgotten that I had them, but,
could you please tell me what kind of errors this statement can retrive(DBCC CHECKDB)?
Thanks
|||

DBCC CHECKDB can determine a variety of problems, ranging from damage to the files themselves to data purity issues.

The DBCC CHECKDB topic in Books online is a great reference.