Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

SSMS 2008 R2 issues

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?
0
martyuni
Asked:
martyuni
  • 5
  • 3
1 Solution
 
SQLSergentMikeCommented:
Is the database in read only mode?
0
 
martyuniAuthor Commented:
Wouldn't that not allow Toad to make modifications?
0
 
martyuniAuthor Commented:
Also, Read-Only is set to False
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SQLSergentMikeCommented:
Right, I forgot you can update it with TOAD. If the permission sets are the same, that doesn't make any sense. Are you sure your using the same credentials? From SSMS query window you execute update table set field = x and that does not change the data? Is there an error? Does the log say anything? What does dbcc opentran return?
0
 
martyuniAuthor Commented:
Tells me blank # of rows affected, go in and check the data and none of it has changed.  Log says successfully executed, but has 0 records updated.
0
 
SQLSergentMikeCommented:
Are you sure your connected to same database, that doesn't make sense. Can you show me the TSQL?
0
 
martyuniAuthor Commented:
I rebooted the machine and reconnected and now I am able to do updates successfully.  Not sure if it was a network issue or what.  Thanks for looking though.
0
 
martyuniAuthor Commented:
Just a reboot.  Possibly a network hiccup.  No real solution
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now