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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-09 : 08:26:55
|
| David writes "When expanding Databases from SQL Enterprise Manager, it shows (No Items), I refreshed the view on the Server and Databases a few times but no luck. The Query Analyzer has no problem to show and access to all databases. What is the problem? Thanks." |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-09 : 12:59:56
|
| Is this a new installation? Enterprise Mangler can be configured to not show system objects and databases. |
 |
|
|
sqlghost
Starting Member
23 Posts |
Posted - 2006-01-17 : 19:52:58
|
| Yeah - good on ya mcrowley - really f*n helpful (not). How about actually posting a solution?How can it be configured to not show databases? What does it matter if it's an old or new installation? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-01-17 : 23:42:03
|
| With an attitude like that, you won't get help from anyone. The people on here post in their spare time, not as part of their job. If you want to be rude, you can struggle through it on your own. You might need real help someday though, so you might want to think twice before being an jackass.Make sure you have the latest MDAC and service packs installed on the client.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-18 : 09:33:12
|
| Wow. Guess I should start taking notes on how to be a helpful person, eh? You seem to be quite the master of it yourself. Of your 6 posts, you have posted one suggestion....which apparently turned out to be a dead-end. (see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50638). But, to answer your questions:Q: How about actually posting a solution?A: Because I do not have enough information from your two-line description of the problem to suggest anything. I am apprently not alone in this, by the fact that only one other person here has hazzarded a guess.Q: How can it be configured to not show databases?A: Apparently you misread my question, as I said EM can be configured to hide SYSTEM tables and databases. If you need hand-holding on finding out how, you may want to consult the manual, click around in Enterprise Manager, or ask nicely.Q: What does it matter if it's an old or new installation?A: New installations will likely only have System tables and databases.I am not sure why you are expecting a packaged solution with pretty bows tied on it on the first post. I am also unsure why you are apparetnlty not willing to think about your own problem. But, I will accept your apology in advance. |
|
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2006-01-20 : 06:39:27
|
| David , If autoclose property of your DB is ON, set it to OFF .That would help . |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-01-20 : 08:20:04
|
quote:
Originally posted by sqlghost
Yeah - good on ya mcrowley - really f*n helpful (not). How about actually posting a solution?How can it be configured to not show databases? What does it matter if it's an old or new installation?
See, I know the answer to this one, it's quite simple.. SQL Server checks who's using it, then if it thinks that person is too rude and stupid to use it, it hides all the databases.. What you need to do to fix it is learn some manners and read the manual and hope you pick something up from that.. |
|
|
|
|
|
|
|
|
Why Databases show (No Item)