Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't see new tables

Status
Not open for further replies.

Rob999

Programmer
May 23, 2002
98
US
Hello everyone. I believe I'm the dbo on my database that I created under my windows login, which resides on a network server. Under this db, dbo is shown as the only user and I'm using Windows authentication. I've created a number of tables, both via query and DTS import. The last two tables I've created are there, but I can't see them in Enterprise Manager.

I know they are there because when I reran the query that produced the first table, I was told the object already existed, plus when I look under users and see sa/dbo, the permissions box shows both the new tables along with the rest of the tables I created (and can see) earlier, with all the same check boxes ticked off. Also, both tables show up in the query analyzer and I can use them in queries!

When I right click and select properties on the db that I created I get an "Error 5:[SQL-DMO] Code Execution Exception: EXCEPTION_ACCESS_VIOLATION". So checking the db properties and seeing my most recent table additions is now a problem. I haven't signed off since yesterday and rarely do so (though I lock the computer via Ctr+Alt+Del), so my login hasn't changed. I'm not sure how much further I want to go with this if there's going to be a problem. Any ideas?
 
Hello again everyone. Within 1 hour of the first table not being visible in the Enterprise Manager, but being available to the system, they're both now visible (and yes, I refreshed the tables view a number of times). I guess it might have been a network transmission problem - or something?
 
Sometimes it takes a total disconnect from the server to reset it. Did you by chance do this or close Enterprise Manager completely and get back in. I have seen the issue where the refresh does not work. Pretty weird I must say!

Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top