x

System Databases are missing!!!!!!

[1]My system database became invisible .I am not able to see system Databases in my instance. I have SYSADMIN rights on my instance and my instance is working good

[1]: /storage/temp/1735-capture123.png

capture123.png (14.9 kB)
more ▼

asked Oct 23, 2014 at 10:39 AM in Default

avatar image

UnishSQL
419 5 10 21

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
  1. Start management studio

  2. Go tools-options-environment-general

  3. Remove selection for "Hide system objects in Object Explorer"

  4. Restart Management Studio

  5. System databases are now visible

more ▼

answered Oct 23, 2014 at 11:32 AM

avatar image

raadee
4.5k 13 18 22

Yes i just got it @radee Thnku

Oct 23, 2014 at 11:35 AM UnishSQL
(comments are locked)
10|1200 characters needed characters left

Step One and Two are shown in pictures below. Please ensure you have that check box DESELECTED. System databases will re-emerge.

Step One and Two are shown in pictures below. Please ensure you have that check box DESELECTED.  System databases will re-emerge.

step1.png (29.5 kB)
step2.png (41.8 kB)
more ▼

answered Oct 24, 2014 at 05:21 PM

avatar image

SQLGoooRooo
241 1 3 6

Go to TOOLS then OPTIONS then ENVIRONMENT then STARTUP then deselect the "Hide system objects in Object Explorer."

Oct 24, 2014 at 05:23 PM SQLGoooRooo
(comments are locked)
10|1200 characters needed characters left

If the instance is working, I'm quite confident you also have system databases running.

What if you run the query

 SELECT * FROM sys.databases

?

more ▼

answered Oct 23, 2014 at 10:41 AM

avatar image

Magnus Ahlkvist
22.1k 20 43 42

ya its working fine but iam not able to see System databases @magnus

Oct 23, 2014 at 10:46 AM UnishSQL

above image can make u understand my problem

Oct 23, 2014 at 11:05 AM UnishSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2198
x783
x447
x25

asked: Oct 23, 2014 at 10:39 AM

Seen: 295 times

Last Updated: Oct 24, 2014 at 05:23 PM

Copyright 2018 Redgate Software. Privacy Policy