I am hoping someone can help me on this. I have lost the ability to see tables in one database. I can see views and have full access rights on this database. I was trying to install OLAP Analysis on my PC and suddenly I lost this capability on one of the databases I access. Any thoughts? I have looked at everything I can find trying to fix this. Have re-installed and even cleared my user and re-added. It is something on my PC alone since it also affects anyone who signs on to my box.
I should tell you I just verified that I was able to log on and see the tables from another machine. I am what passes for the DBA in my world. I can see other databases and all of their tables. This is our data warehouse database. I am supposed to have the highest level rights. As I say I am thinking perhaps it is something on my machine but uninstalling and re-installing SQL 7 did not change anything. Do you know if there is anything in the registry that might be causing this?
Just to clear some of the usual problems. Have you tried right clicking on the tables icon in the left pane and selecting refresh? EM is notorious for needing to be refreshed manually. Also, Since you have SQL 7.0 enterprise manager on your machine, did you install Analysis Services from the same SQL 7.0 disk, or from a SQL 2000 disk? Kind of grasping at straws here...
Thanks to all for your responses.
I used the same disk SQL 7.0. Don't feel bad I am grasping at straws too. I've been fighting with this for about 3 weeks. Yes I have refreshed and gotten the same result. I can't delete or change the database since it is our data warehouse and I really don't want to completely rebuild my pc from scratch if I don't have to do so. I have several large Access databases on it I would have to do something with. Plus several months worth of archived data. I can move it all to the server but it will mean I am out of commision for a couple of days and it's year end. I can get by for the short term with using another box to access but it is a pain and I just want to know what happened. This was my last resort. My network person and I could find nothing on tech net or the microsoft site about this kind of problem. I guess I was hoping someone might have encountered the problem and knew what to do.
Can you be more precise as to the process activity and where I can find it? I am not very good on the server end of this yet. I have just started working on my MSDBA and have a lot to learn. I'm much better at ACCESS. Don't have a lot of trouble with SQL but as I say have not worked with the server itself that much.
Originally posted by rnealejr
He was referring to current activity under management. However, you say this is sql server 7 - is this sql server (oltp) or analysis server (olap) ?
This is OLTP. I am taking a course on Data Warehouse and was hoping to do some work on the OLAP Analysis. We had not had occasion to really use this type of processing before and I wanted to see what it might gain us.
Originally posted by rnealejr
Left this off:
He was referring to current activity under management in enterprise manager.
I was asking about analysis server because in sql server 7, the sql server and analysis server are separate.
Thanks for the heads up. I found where he was referring to and will try what he asked. As for what you referred to that may explain part of why I am having a problem. At any rate it definitely explains why we haven't been using any of the OLAP processes. I believe that I may have tried to access the data Warehouse database just to look at it in the OLAP. As I say I think that is what I did but I just can't seem to get my references back to the original settings. I know it is on my machine and I have uninstalled both SQL7 and OLAP and re-installed only the SQL7 but it remains the same and I am not sure why. I am just about resigned to getting thru this year end and then reloading my operating system. I just hope that will fix it.I do appreciate the suggestions and help. This is really a great source of information. I am interested in seeing what others have encountered also.