I've run into a very strange problem. I'm developing an app using SQLExpress using VC 2010. I also have SQL Management Studio installed. If I add information to the db with the application I am writing it shows up in vc2010 but not SQL Management Studio.
At first I thought I had 2 different SQLExpress instances on the machine, but that is not the case.
I first noticed the problem when doing a simple COUNT(*) on one of the tables. Got a different count from Management Studio than VC 2010. I shut down SQL Management Studio, then restarted it running it as Administrator. Ran the same Count(*) query again
and the counts matched between SQL Management studio and VC 2010. Shut it down, ran as a normal user again, did the same query and the counts again did not match. Run again as Administrator and the counts match.
That's not all.....I've since been running SQL Management Studio exclusively as Administrator and am now running into the same sort of problem. Records ad ...
Go to the complete details ...