<thecfguy blog="sharing thought">

I have recently installed window 7 and everything was going perfect but suddenly found problem with @ sign. Whenever I tried to print @ sign it was printing double quotes (") instead, same issue with other characters as well. Backslash (\), number sing (#) was also replace with other characters. 

Just doing research on this and found it is because of regional language setting. Default language set with English (United Kingdom). I don't know this is common for UK people but this issue occurs to me first time and I thought it's keyboard issue at first instance but later same issue I found in my friends computer. This can be resolved by changing language to English (United state) from English (United Kingdom).

Follow below steps to change language settings. 

1.  Press window key and search "Region" and click on "Region and Language" option.
2. In popup window select English (United States) from dropdown.
3. Goto "Keyboards and Language" tab. Click on "Change Keyboards" select default input language to English (United States).
4. And Finally Change system Local to "United States" ( It may ask to restart your computer).

I really love database diagram feature of SQL server. Recently I have installed Sql server 2008 edition and it diagram feature stop work for me. Showing below annoying error although I have dbowner rights.

"Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."

After doing googling I found solution and it is really simple. Do following steps to enable database diagram.

1. Highlight database for which you want to enable database diagram.
2. Select Property from context menu.
3. Highlight Options and choose SQL Server 2005 (90) from compatibility level dropdown.
4. Highlight Files options and set owner SA or any other user who has dbowner rights. You can click on button next to text field to search available user.
5. Click on OK to save changes.
6. Try to access "Database Diagrams" option again (You may need to refresh the database).