October 9, 2005 at 11:50 pm
Hi ,
I am amid resolving a wierd issue.
The database i am trying to query would let me query all the tables present in the database.there are almost a 1000 of them.I can query them and i get the records.
But the execution of the stored procedure "sp_tables" would return only one table.I was puzzled by this.
can someone clarify this inconsistency.
thank you
October 12, 2005 at 8:00 am
This was removed by the editor as SPAM
October 12, 2005 at 11:59 am
Look carefully at the output. All of the tables and views are listed in the column TABLE_NAME. You may be looking at the TABLE_QUALIFIER column.
October 13, 2005 at 6:43 am
Are you getting back one record? Or 1000? If you are getting 1000, I would tend to agree with JackSteezo - Otherwise, please post your entire t-sql statement for us to look at. I just tried it on several DBs in its default form:
execute
sp_tablesand it performed as expected. Are you supplying any parameters?
October 13, 2005 at 11:03 am
i am not supplying any parmaters.
Execute sp_tables
i am getting one regular table and may be 10 other system tables and that is it
October 13, 2005 at 11:32 am
What user are you logging in as? SA?
October 13, 2005 at 3:51 pm
i am new here and they kust gave me the query access
October 13, 2005 at 4:58 pm
You are probably only seeing tables that your login has been granted access to. That is the most likely scenario. Are you able to open and use the Management Studio? If so, you should only be able to see tables that your login has access to. If you are a developer, you should have appropriate access to the tables you need - check with your IT department.
October 13, 2005 at 4:58 pm
You are probably only seeing tables that your login has been granted access to. That is the most likely scenario. Are you able to open and use the Management Studio? If so, you should only be able to see tables that your login has access to. If you are a developer, you should have appropriate access to the tables you need - check with your IT department.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply