sql server base tables











up vote
3
down vote

favorite












I use SQL Server 2012.



How can select from sql server system base table such as below tables.




  • sys.sysschobjs

  • sys.sysbinobjs

  • sys.sysclsobjs


When I get query from base system table such as below query. get following error.



select * from sys.sysschobjs


Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.sysschobjs'.









share|improve this question






















  • Are you running the query in the Master database?
    – JohnFx
    Jan 3 '14 at 17:14










  • @JohnFx. Yes. I get query on master database.
    – mehdi lotfi
    Jan 3 '14 at 17:16












  • are you sure. Try running USE Master before running this query.
    – JohnFx
    Jan 3 '14 at 17:18










  • @JohnFx. I add Use Master; above of my query. but the result of my query don't change.
    – mehdi lotfi
    Jan 3 '14 at 17:21















up vote
3
down vote

favorite












I use SQL Server 2012.



How can select from sql server system base table such as below tables.




  • sys.sysschobjs

  • sys.sysbinobjs

  • sys.sysclsobjs


When I get query from base system table such as below query. get following error.



select * from sys.sysschobjs


Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.sysschobjs'.









share|improve this question






















  • Are you running the query in the Master database?
    – JohnFx
    Jan 3 '14 at 17:14










  • @JohnFx. Yes. I get query on master database.
    – mehdi lotfi
    Jan 3 '14 at 17:16












  • are you sure. Try running USE Master before running this query.
    – JohnFx
    Jan 3 '14 at 17:18










  • @JohnFx. I add Use Master; above of my query. but the result of my query don't change.
    – mehdi lotfi
    Jan 3 '14 at 17:21













up vote
3
down vote

favorite









up vote
3
down vote

favorite











I use SQL Server 2012.



How can select from sql server system base table such as below tables.




  • sys.sysschobjs

  • sys.sysbinobjs

  • sys.sysclsobjs


When I get query from base system table such as below query. get following error.



select * from sys.sysschobjs


Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.sysschobjs'.









share|improve this question













I use SQL Server 2012.



How can select from sql server system base table such as below tables.




  • sys.sysschobjs

  • sys.sysbinobjs

  • sys.sysclsobjs


When I get query from base system table such as below query. get following error.



select * from sys.sysschobjs


Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.sysschobjs'.






sql sql-server sql-server-2012






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Jan 3 '14 at 17:12









mehdi lotfi

6,8761359115




6,8761359115












  • Are you running the query in the Master database?
    – JohnFx
    Jan 3 '14 at 17:14










  • @JohnFx. Yes. I get query on master database.
    – mehdi lotfi
    Jan 3 '14 at 17:16












  • are you sure. Try running USE Master before running this query.
    – JohnFx
    Jan 3 '14 at 17:18










  • @JohnFx. I add Use Master; above of my query. but the result of my query don't change.
    – mehdi lotfi
    Jan 3 '14 at 17:21


















  • Are you running the query in the Master database?
    – JohnFx
    Jan 3 '14 at 17:14










  • @JohnFx. Yes. I get query on master database.
    – mehdi lotfi
    Jan 3 '14 at 17:16












  • are you sure. Try running USE Master before running this query.
    – JohnFx
    Jan 3 '14 at 17:18










  • @JohnFx. I add Use Master; above of my query. but the result of my query don't change.
    – mehdi lotfi
    Jan 3 '14 at 17:21
















Are you running the query in the Master database?
– JohnFx
Jan 3 '14 at 17:14




Are you running the query in the Master database?
– JohnFx
Jan 3 '14 at 17:14












@JohnFx. Yes. I get query on master database.
– mehdi lotfi
Jan 3 '14 at 17:16






@JohnFx. Yes. I get query on master database.
– mehdi lotfi
Jan 3 '14 at 17:16














are you sure. Try running USE Master before running this query.
– JohnFx
Jan 3 '14 at 17:18




are you sure. Try running USE Master before running this query.
– JohnFx
Jan 3 '14 at 17:18












@JohnFx. I add Use Master; above of my query. but the result of my query don't change.
– mehdi lotfi
Jan 3 '14 at 17:21




@JohnFx. I add Use Master; above of my query. but the result of my query don't change.
– mehdi lotfi
Jan 3 '14 at 17:21












2 Answers
2






active

oldest

votes

















up vote
4
down vote



accepted










It is doable if you used a "Database Engine Query", and an administrator user.
To do so, after you open the SQL Management Studio:
Click File Menu, "New" sub menu, and select "Database Engine Query".
In the server name, write "Admin:" before your server name (eg., if your server name is "localhost", then the full server name to be written is "admin:localhost")
Then write your credentials (for administrative account).



N.B.: Make sure that there are no other administrator logged in to the Database Engine Query other than you (I believe it is a single access point)



For more information:



http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx



http://zarez.net/?p=774






share|improve this answer




























    up vote
    4
    down vote













    To query this system base tables needs a Dedicated Administrator Console (DAC).




    First, connect to your database using the DAC. To do this from SQL
    Server Management Studio, go to File -> New -> Database Engine Query.
    Put ADMIN: in front of your instance name and click Connect.




    Change to the your database using the USE [mydb]



    Now you can query



    select * from sys.sysschobjs


    See this post for further info on this:



    http://www.hackingsqlserver.com/



    https://sqlblog.org/2011/11/08/t-sql-tuesday-24-dude-wheres-the-rest-of-my-procedure






    share|improve this answer























      Your Answer






      StackExchange.ifUsing("editor", function () {
      StackExchange.using("externalEditor", function () {
      StackExchange.using("snippets", function () {
      StackExchange.snippets.init();
      });
      });
      }, "code-snippets");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "1"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














       

      draft saved


      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f20909077%2fsql-server-base-tables%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes








      up vote
      4
      down vote



      accepted










      It is doable if you used a "Database Engine Query", and an administrator user.
      To do so, after you open the SQL Management Studio:
      Click File Menu, "New" sub menu, and select "Database Engine Query".
      In the server name, write "Admin:" before your server name (eg., if your server name is "localhost", then the full server name to be written is "admin:localhost")
      Then write your credentials (for administrative account).



      N.B.: Make sure that there are no other administrator logged in to the Database Engine Query other than you (I believe it is a single access point)



      For more information:



      http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx



      http://zarez.net/?p=774






      share|improve this answer

























        up vote
        4
        down vote



        accepted










        It is doable if you used a "Database Engine Query", and an administrator user.
        To do so, after you open the SQL Management Studio:
        Click File Menu, "New" sub menu, and select "Database Engine Query".
        In the server name, write "Admin:" before your server name (eg., if your server name is "localhost", then the full server name to be written is "admin:localhost")
        Then write your credentials (for administrative account).



        N.B.: Make sure that there are no other administrator logged in to the Database Engine Query other than you (I believe it is a single access point)



        For more information:



        http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx



        http://zarez.net/?p=774






        share|improve this answer























          up vote
          4
          down vote



          accepted







          up vote
          4
          down vote



          accepted






          It is doable if you used a "Database Engine Query", and an administrator user.
          To do so, after you open the SQL Management Studio:
          Click File Menu, "New" sub menu, and select "Database Engine Query".
          In the server name, write "Admin:" before your server name (eg., if your server name is "localhost", then the full server name to be written is "admin:localhost")
          Then write your credentials (for administrative account).



          N.B.: Make sure that there are no other administrator logged in to the Database Engine Query other than you (I believe it is a single access point)



          For more information:



          http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx



          http://zarez.net/?p=774






          share|improve this answer












          It is doable if you used a "Database Engine Query", and an administrator user.
          To do so, after you open the SQL Management Studio:
          Click File Menu, "New" sub menu, and select "Database Engine Query".
          In the server name, write "Admin:" before your server name (eg., if your server name is "localhost", then the full server name to be written is "admin:localhost")
          Then write your credentials (for administrative account).



          N.B.: Make sure that there are no other administrator logged in to the Database Engine Query other than you (I believe it is a single access point)



          For more information:



          http://technet.microsoft.com/en-us/library/ms178068(v=sql.105).aspx



          http://zarez.net/?p=774







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jan 3 '14 at 17:38









          CodingMate

          303312




          303312
























              up vote
              4
              down vote













              To query this system base tables needs a Dedicated Administrator Console (DAC).




              First, connect to your database using the DAC. To do this from SQL
              Server Management Studio, go to File -> New -> Database Engine Query.
              Put ADMIN: in front of your instance name and click Connect.




              Change to the your database using the USE [mydb]



              Now you can query



              select * from sys.sysschobjs


              See this post for further info on this:



              http://www.hackingsqlserver.com/



              https://sqlblog.org/2011/11/08/t-sql-tuesday-24-dude-wheres-the-rest-of-my-procedure






              share|improve this answer



























                up vote
                4
                down vote













                To query this system base tables needs a Dedicated Administrator Console (DAC).




                First, connect to your database using the DAC. To do this from SQL
                Server Management Studio, go to File -> New -> Database Engine Query.
                Put ADMIN: in front of your instance name and click Connect.




                Change to the your database using the USE [mydb]



                Now you can query



                select * from sys.sysschobjs


                See this post for further info on this:



                http://www.hackingsqlserver.com/



                https://sqlblog.org/2011/11/08/t-sql-tuesday-24-dude-wheres-the-rest-of-my-procedure






                share|improve this answer

























                  up vote
                  4
                  down vote










                  up vote
                  4
                  down vote









                  To query this system base tables needs a Dedicated Administrator Console (DAC).




                  First, connect to your database using the DAC. To do this from SQL
                  Server Management Studio, go to File -> New -> Database Engine Query.
                  Put ADMIN: in front of your instance name and click Connect.




                  Change to the your database using the USE [mydb]



                  Now you can query



                  select * from sys.sysschobjs


                  See this post for further info on this:



                  http://www.hackingsqlserver.com/



                  https://sqlblog.org/2011/11/08/t-sql-tuesday-24-dude-wheres-the-rest-of-my-procedure






                  share|improve this answer














                  To query this system base tables needs a Dedicated Administrator Console (DAC).




                  First, connect to your database using the DAC. To do this from SQL
                  Server Management Studio, go to File -> New -> Database Engine Query.
                  Put ADMIN: in front of your instance name and click Connect.




                  Change to the your database using the USE [mydb]



                  Now you can query



                  select * from sys.sysschobjs


                  See this post for further info on this:



                  http://www.hackingsqlserver.com/



                  https://sqlblog.org/2011/11/08/t-sql-tuesday-24-dude-wheres-the-rest-of-my-procedure







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Nov 10 at 21:36









                  Aaron Bertrand

                  206k27358401




                  206k27358401










                  answered Jan 3 '14 at 17:38









                  Rahul

                  61.5k114380




                  61.5k114380






























                       

                      draft saved


                      draft discarded



















































                       


                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f20909077%2fsql-server-base-tables%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Popular posts from this blog

                      Florida Star v. B. J. F.

                      Danny Elfman

                      Retrieve a Users Dashboard in Tumblr with R and TumblR. Oauth Issues