Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sherrys
Starting Member
37 Posts |
 Posted - 2004-12-02 : 15:55:45
|
| Ever since I installed service pack 2 for XP, I often get messages in Query Analyzer's Object browser:'Could not find object. It may have been dropped. Refresh at a higher level.'I right click 'refresh' on the server and everything is fine, but it is a pain in the butt. What do I need to change to stop this? Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-02 : 15:57:42
|
| I seriously doubt this has to do with XPSP2. It sounds like someone is dropping objects on you and the object browser needs to be refreshed to reflect the changes. Maybe you are doing drop and creates in the query window?Tara |
 |
|
|
sherrys
Starting Member
37 Posts |
Posted - 2004-12-02 : 16:12:44
|
| No, that is not it. I just got another annoying message again. I seems to be related to idle time. This is the message this time. Communication link failure. Connection to the server has been broken. Do you wish to reconnect now? I say yes. it doesn't help. I have to refresh at the server level. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-02 : 16:14:55
|
| Well that's a connection issue and is different and not related to your other error. You've lost connectivity to the SQL Server temporarily.Tara |
|
|
|
sherrys
Starting Member
37 Posts |
Posted - 2004-12-02 : 16:36:00
|
| Yep, I agree. But I think they are related. If I had previously expanded the server, and the database, so that I have a list of tables on the browser. Then I lose connectivity, and click on a table. It says "Could not find Object". I also really think this started after I installed XP SP2. Which is supposed to have all kinds of great security. The security is so great, it cuts off my connection to the SQL server. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-02 : 16:39:37
|
| The security has to do with if you are running SQL Server (not the client tools, but rather the database engine) on XP with service pack 2, then the firewall on SP2 will prevent outside clients/machines from connecting to this SQL Server. The key part is outside clients. So if you are just trying to connect to a SQL Server locally then there is no SP2 firewall issue. You have to enable it to work for outside clients. Other than that though, SP2 doesn't change security for SQL Server.Tara |
|
|
|
|
|
|
XP Professional Service Pack 2