Results 1 to 15 of 15
  1. #1
    Join Date
    Nov 2009
    Posts
    21

    Unanswered: Looking for data in a table

    Hello:

    I want to know if anyone knows how can I look for a record in a table. Probably using the sp_procedure. Not sure how. I have no idea what table it uses. I only have the data that I need to look for in sql server 2005. I am looking for the value that holds in a table within project server 2007. The back end is sql server 2005.

    Thank you for your assistance
    kkmickey

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You have a row that is shown in your application and you want to know which table in your database that row is in? You believe this row is retrieved by a stored procedure?

    Is this correct?

  3. #3
    Join Date
    Nov 2009
    Posts
    21
    I am sorry I should make that more clear.
    For example: I am looking for a value contains "ABC" in a field. It is located somewhere in one of the sql server tables. I just don't know where. I was thinking is there a system procedure that can help me to track the data to see which table the data is located in.

    Thank you
    kkmickey

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Well for that I was going to suggest Blindman's script!

  6. #6
    Join Date
    Nov 2009
    Posts
    21
    Thank you so much.

  7. #7
    Join Date
    Nov 2009
    Posts
    21
    It works thank you so much.
    Blindman and pottle flump.

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    ...might as well call me poodle and be done with it...

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    It's because you don't have a catchy cool nickname, like "blindman".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I even got to make mine up myself

  11. #11
    Join Date
    Nov 2009
    Posts
    21
    I am sorry pootle that I mistyped your name. I do appreciate your assistance.

  12. #12
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Don't worry about abusing Poots... It is a favorite passtime here at DBForums!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Hell, Pat Fellan can't even spell his own name.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You should see how my mail is addressed from the folks that have heard but never seen my name. I have to give them points for creativity.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Jim Carr: Andre "Poodle" Lussier, defense. Andre, as you know, has been living in semi-seclusion in Northern Quebec ever since the unfortunate Denny Pratt tragedy.
    Morris Wanchuk: Not Poodle.
    I thought you spelled it wrong
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •