Alter User

  • okbangas

    SSChampion

    Points: 11773

    Comments posted to this topic are about the item Alter User



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • TomThomson

    SSC Guru

    Points: 104772

    Nice straightforward question. I had to do some reading because I didn't know teh answer, but for me that makes it a good question.

    But I wonder why this strange restriction that alter user can't provide a login for a user who doesn't already have one exists. Presumably MS has some reason for it, but BoL just tells us about the restriction and doesn't give any reason for it (tha's fairly standard for BoL, of course).

    Tom

  • mickyT

    SSChampion

    Points: 10360

    Nice question thanks.

  • Lokesh Vij

    SSChampion

    Points: 10836

    Nice question to start with on Monday Morning. Got to learn something, I was not aware of. Thanks:-)

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    Nice question with having good basic information.

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Interesting question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • demonfox

    SSCertifiable

    Points: 6289

    Koen Verbeeck (2/18/2013)


    Interesting question, thanks.

    +1

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • Iulian -207023

    SSCertifiable

    Points: 7508

    Nice one, thanks

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Interesting question, thank you for posting.

    Did not tried this before, so had really no idea , but bit search on offline BOL, was able to guess that opt-3 may be the answer.

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

  • Dineshbabu

    Hall of Fame

    Points: 3220

    Raghavendra Mudugal (2/18/2013)


    Did not tried this before, so had really no idea , but bit search on offline BOL, was able to guess that opt-3 may be the answer.

    +1

    --
    Dineshbabu
    Desire to learn new things..

  • Dineshbabu

    Hall of Fame

    Points: 3220

    If somebody explains step by step on actually what happening will be very helpful..

    --
    Dineshbabu
    Desire to learn new things..

  • This was removed by the editor as SPAM

  • sestell1

    SSChampion

    Points: 10230

    Wow, interesting... and very odd.

    I'd be curious to know the reason behind this restriction.

  • Revenant

    SSC-Forever

    Points: 42467

    Really good one -- thanks!

  • Venkat Jonnalagadda

    Mr or Mrs. 500

    Points: 510

    Got this one right after a lot of reading.. Thanks for a good qotd..

    ___________________________________________________________________
    If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:

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

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