I just installed SSMS 2008 R2 and having some problems with it. I can connect to my databases on other servers using window authentication. This account has full rights to the databases. But insert and update statements don't work. Says they complete successfully but no changes to the data. I have refreshed and also disconnected and reconnected to check. Another thing is if I try to edit a field length or null value acceptance in a table it says I have to drop and recreate the table. I also installed Express 2008 on my machine and same things are happening. I can do all of the following successfully using Toad, but there are things I like to do in SSMS that are easier for me to do. I am an admin on the box, I have used my domain admin account and did the right click "Run as Administrator". Thoughts or some setting I need to change?