Post reply

Can we open the system databases in MSDB???

  • July 15, 2009 at 11:29 am

    #155968

    hello,

    I'm trying to open system tables from Management studio to see what the information is there. But the Open table option is greyed out. Is this normal? Is it not allowed to open system tables in msdb?

    thanks

  • July 15, 2009 at 11:30 am

    #1025247

    Yes you can view the data, if you have the appropriate access.

  • July 15, 2009 at 11:42 am

    #1025255

    I'm the Administrator of that sql server, but I'm not able to open the system tables in MSDB. The open table option is greyed out!!!

  • July 15, 2009 at 1:11 pm

    #1025298

    I have found that the system tables do not allow you to right click and select Open Table. You have to issue a select command:

    SELECT * FROM sysjobs

  • July 15, 2009 at 1:37 pm

    #1025320

    You typically do not "open" system tables, especially in SSMS since that is an editing window.

    Most of the information from system tables appears in SSMS. What exactly are you trying to view?

  • July 15, 2009 at 3:18 pm

    #1025394

    Just to confirm that we can not open system tables in SSMS..

    I able to query and see the data using t-sql commands though

    Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply