sp_tables issue

• krishna reddy-267698

  Old Hand

  Points: 380

  More actions

  October 10, 2005 at 12:58 am

  #166237

  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 please clarify this inconsistency.

  thank you

• philcart

  SSC-Forever

  Points: 47795

  More actions

  October 10, 2005 at 1:31 am

  #596213

  Please do not cross-post, it just confuses things.

  You've already posted this message

  here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=227521

  and

  here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=227532

  Which one would you like replies to??

   

  --------------------
  Colt 45 - the original point and click interface