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?
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?