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'.
sql sql-server sql-server-2012
add a comment |
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'.
sql sql-server sql-server-2012
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
add a comment |
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'.
sql sql-server sql-server-2012
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
sql sql-server sql-server-2012
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
add a comment |
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
add a comment |
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
add a comment |
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
add a comment |
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
add a comment |
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
add a comment |
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
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
answered Jan 3 '14 at 17:38
CodingMate
303312
303312
add a comment |
add a comment |
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
add a comment |
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
add a comment |
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
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
edited Nov 10 at 21:36
Aaron Bertrand
206k27358401
206k27358401
answered Jan 3 '14 at 17:38
Rahul
61.5k114380
61.5k114380
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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