Not Again!

  • sknox


    Points: 12292

    Comments posted to this topic are about the item Not Again!

  • This was removed by the editor as SPAM

  • twin.devil


    Points: 22208

    good question. reminded me some old thoughts 🙂



    Points: 5507

    twin.devil (2/18/2015)

    good question. reminded me some old thoughts 🙂

  • Raghavendra Mudugal


    Points: 10658

    Thank you for the post, good one. Memory recall, remembered doing this in SQL 2000 instance for one app_user.

    (actually it was not hard to find out the right choice - I knew it was not the permission denial on definition, never knew what that 9485 flag did so had to check on that, and the remaining one must have been correct...)

    ww; Raghu
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.


    SSC Eights!

    Points: 847

    Could this be a reason for preferring Count(1) over Count(*) - which is otherwise not an easy decision.

    Edit: No indeed, I misread the question.

  • Toreador


    Points: 11257

    Surely this must be a bug?


    SSC Eights!

    Points: 847


  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Very interesting question, thanks.

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hany Helmy


    Points: 13488

    Learned somthing new for me today, thanx!

  • Brian.Klinect

    Mr or Mrs. 500

    Points: 592

    I learned to today that I can set permissions at the column level. Never even considered trying to do that before.

    I really liked the story that went with the question. Keep up the good storytelling!

  • Bhushan Kulkarni


    Points: 2829

    Very interesting question

  • Dave62


    Points: 6664

    I got it right but I don't think Steve got the answer to his question.

    Steve asked the simplest request: how many users on the website?

    I would interpret that question to mean how many users are currently logged on to the website, which is most likely not the total number of ID's in the users table. It's probably a rare occasion, if ever, that all users are logged on at the same time.


  • Dana Medley


    Points: 6764

    Thanks for the question.

    Everything is awesome!

  • RK Mandava

    SSCarpal Tunnel

    Points: 4153

    Good one, Memory recall.

Viewing 15 posts - 1 through 15 (of 23 total)

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