Post reply

getting user details of a table

  • April 12, 2011 at 4:58 am

    #236505

    Hi ,

    I have logged into server with particular user credentials and created some table.Now I need get the details of those tables which are created by this user.

    I found principal_id column in both sys.server_principals table and sys.tables,but sys.tables table has null values....

    where as sys.server_principals table holds unique value for one user.....

    Is there any way to resolve this?

    Help me please....

    Thanks in advance......

  • April 12, 2011 at 5:19 am

    #1310291

    duplicate post. please don't post the same question multiple times, it makes it hard to follow and fragments replies.

    users click Recent Posts>>Posts Added Today to see all recent activity.

    follow the thread here;

    http://www.sqlservercentral.com/Forums/Topic1091968-145-1.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

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