David Hubbard


In my instance of "sql server 2005" I right click on a table and select "Open Table" then I get the error message "Object reference not set to..." Then has been happening since I installed I have tryed searching groups and posting to get a solution. I have load the adventure works data base and get the same error when performing "open table". Can someone from MS please respond. Also if Open Table works can you edit the data directly in the results pane




Re: "Open Table" NOT WORKING. Can someone HELP!

hipswich


I had very similar problem. The problem was gone after I installed SP2.





Re: "Open Table" NOT WORKING. Can someone HELP!

Satya SKJ

Have you tried to attempt from another client's machine against this server

Also test and try using SP2 on SQL 2005, if it is not a SQL 2005 instance then make sure to have latest service pack on SQL 2000 too.







Re: "Open Table" NOT WORKING. Can someone HELP!

hipswich

I am sorry but I should have been more specific about what happened in my case. Here is the story:

The instance of SQL 2005 is on machine A and I had no problem in accessing the tables from machine A. The problem was with machine B on which I was running Management Studio to access the SQL server on machine A. I could connect, open the database, display columns of the tables, but whenever I tried to open a table to browse data or modify the table, I got the error. I installed SQL 2005 SP2 on machine B and the problem was gone. Apparently something was wrong with the instance of Management Studio on machine B. It worked fine flawlessly for a very long time. I have no clue what caused the problem for SSMS.