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 |
|
spinoza
Starting Member
49 Posts |
 Posted - 2006-01-06 : 22:22:29
|
| Most of the times I cant see my database tables from the query analyser in the object browser window... There are some times that appear normally...but in mosto of cases they just dont appear at all...I can only see the master database and msdb... I am connecting giving the proper password...bear in mind that I can write and execute queries to my database although I cant see the tablesWhy could this be happened??? Is a matter that i have discussed with my hosting provider or I am missing something here??? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-01-06 : 23:07:36
|
| first thing I would check is to make sure you have applied the latest service pack for SQL Server in order to update your client tools. I am assuming you have installed the client tools separately on your workstation and you are connecting to a remote server. If this is the case, then you should install the SQL Service pack to your workstation in order to update the tools. I personally have applied SQL SP4 to my client machines, and have installed only sp3a on many of my servers.also, it is important to make sure the SQL Server itself is updated to at least SP3a. You may want to hold off on putting SP4 on your Server as some people have experience performance problems with the update. This is what we have done in a couple of cases, but we will be rolling out SP4 to all boxes soon. This is a separate discussion though, but you can search through the forums here for information on the problems some people have had after applying SP4 to their servers.Anyway, start with updating the client tools and let us know if that fixes things.-ec |
 |
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-07 : 06:02:42
|
| I have made the installation only...no update of any serial patch... From where I can download it??? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-07 : 13:51:33
|
| "I personally have applied SQL SP4 to my client machines, and have installed only sp3a on many of my servers"Now that's an idea I like the sound of. Why didn't I think of that ...Kristen |
|
|
|
|
|
|
Object browser