• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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