Number of rows are different in Query Analyser and E.M.

  • Hello Friends,

    Recently I came one problem, when i opened Sql Enterprise Manager, on right side of window list of Tables, there when i right click  on table and i am getting total number of rows say 5 but when i double click then here i am getting 12 rows!!!!!!!!!!!!!!

    How That possible?????

    I checked through Query Analyser also there also i am getting 5 rows!!!

    Can Any body know this

    Please Help me out!!!!!!!!!

    Thanks In Advance

    Shashank


    Regards,

    Papillon

  • Check again, aren't the 12 "rows" actually a list of your columns?


    Have Fun!
    Ronzo







  • **ASCII stupid question, get a stupid ANSI !!!**

  • With the lack of follow up from the starter of the thread, I'll assume that this has been answered .

  • Hello..

     

    That was the case but that solved when i updated my sql statistics then that is showing correct results

     

    thanks

    regards

    shashank


    Regards,

    Papillon

  • That was my other solution .

  • Any way thanks for your help

     

    shashank


    Regards,

    Papillon

Viewing 7 posts - 1 through 6 (of 6 total)

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