How Do I resolve SSMS 'is busy" issue

  • JC-3113

    SSCrazy Eights

    Points: 8366

    Hi Brandie

    you know what i did was replied to OLDHAND where i stated the SP3.

    My bad ..

    as far as the Maint Plans

    I just changed several tasks

    and did some renames of some test plans i have to test the right click fix

    i have not narrowed it down to any one particular issue within the maint plans

    i would have to spend some time to do that and see if there is any commonality

    Jim

  • Brandie Tarvin

    SSC Guru

    Points: 172545

    Other than calling Microsoft, that's the next best thing I can recommend. Try to narrow it down to a common denominator.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • JC-3113

    SSCrazy Eights

    Points: 8366

    ok Brandie

    thanks for your input

    jim

  • bochambers

    Say Hey Kid

    Points: 700

    You sir, are a legend! Sorry for bumping a 6 year old post, but I have started getting this issue after installing some .Net and Visual Studio libraries which seem to be creating this same issue. The right click on the system tray icon works a treat!

    FYI, I'm running SSMS 2014 on Windows 7 SP1.

  • five_ten_fiftyfold

    Ten Centuries

    Points: 1139

    So I come across this thread nine years and several iterations of SSMS after the event, totally fed up with having to restart SSMS repeatedly, often losing work along the way. I think to myself, there's no way on earth this is going to work.

    It only did work though! My flabber was well and truly gasted. @JC-3113, if you're still a denizen of these parts, please accept my sincere thanks.

  • Jeff Moden

    SSC Guru

    Points: 995089

    five_ten_fiftyfold wrote:

    So I come across this thread nine years and several iterations of SSMS after the event, totally fed up with having to restart SSMS repeatedly, often losing work along the way. I think to myself, there's no way on earth this is going to work. It only did work though! My flabber was well and truly gasted. @JC-3113, if you're still a denizen of these parts, please accept my sincere thanks.

    It was actually the "Meet George Jetson" user (Chris Powell) at the following post on this thread.  Here's the link...

    https://www.sqlservercentral.com/forums/topic/how-do-i-resolve-ssms-is-busy-issue#post-1223186

    • This reply was modified 5 months, 3 weeks ago by  Jeff Moden.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • five_ten_fiftyfold

    Ten Centuries

    Points: 1139

    Right you are.

    Here's to you, Meet George Jetson / Chris Powell.

Viewing 7 posts - 16 through 22 (of 22 total)

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