Post reply

sp_tables issue

  • October 10, 2005 at 12:59 am

    #89467

    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 10, 2005 at 1:32 am

    #596214

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

    You've already posted this message

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

    and

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

    Which one would you like replies to??

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

  • October 10, 2005 at 11:31 am

    #596339

    u culd reply to this one

  • October 11, 2005 at 12:25 am

    #596442

    When permissions are granted to a Windows NT group, the users of the group will not be able to see a list of the tables for which they were given permissions.

    Enumerate the users of the group using "xp_logininfo '<groupname>', members" or by using the Windows NT command line "NET LOCALGROUP <groupname>". Then grant access to the necessary tables for the Windows NT users.

    Microsoft has confirmed this to be a problem in SQL Server

     7.0. This problem has been corrected in U.S. Service Pack 1

    for Microsoft SQL Server 7.0.

Viewing 4 posts - 1 through 3 (of 3 total)

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