Post reply

Pausing

  • September 17, 2014 at 8:52 am

    #1746096

    Thank you for the post, Steve, interesting one, I never tried this before, so had to check practically.

    I started the service via powershell, then launched the cmd window and then, Sqlcmd, connected to the local database and then executed a simple query. Now I paused the service using Net command and then launched the another cmd window and typed sqlcmd and got the below message.

    C:\>sqlcmd

    Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed for user ''..

    Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : SQL Server service has been paused. No new connections will be allowed. To resume the service, use SQL Computer Manager or

    the Services application in Control Panel..

    But when I executed the query in the first cmd window after pausing, it did execute the statement with no issues.

    Learnt new stuff. 🙂

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

  • September 17, 2014 at 9:03 am

    #1746106

    Thanks! Great question - even though I got it wrong, I learned something.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • September 17, 2014 at 10:18 am

    #1746149

    SqlMel (9/17/2014)

    This was a good question, Steve. Thanks.

    +1 - First thought was right but it came so quick I had to rethink a couple of things. I looked for a twist in the wording or a trick, some of the questions have been really sneaky. I found no trick so answered correctly. You rally got to watch even when it appears to be easy.

    Thanks,

    M.

    Not all gray hairs are Dinosaurs!

  • September 17, 2014 at 11:12 am

    #1746174

    Interesting to know you can't start a new DAC session when the service is paused.

    I was wondering about that. Thanks Hany Helmy!

    Yep.This got me thinking.

    Got it right because found nothing wrong with the answer I selected as the correct one 🙂

    ---------------
    Mel. 😎

  • January 21, 2015 at 10:40 am

    #1771932

    I must confess that I did not know this, and had to look it up. Thanks SSC!

Viewing 5 posts - 16 through 19 (of 19 total)

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