Post reply

SQL instance and SQL AGENT icons

  • June 30, 2008 at 8:54 am

    #189876

    Anyone know of a good link describing the different icons and what they mean? I have been looking all over and I appear to have poor google skills. I am trying to find a description of all the different icons next to sql server instances and sql server agent. For instance, a little red squiggly line on the instance icon or a clock on the sql server agent icon. I can't seem to find explainations for these in my searching. Thanks

  • June 30, 2008 at 9:54 am

    #836229

    Not sure what you mean by the red squiggly on instances, and I think SQL Server Agent always has a clock on the icon (because it's essentially a scheduling tool). Think you could include some screen-shots of what you're talking about?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • June 30, 2008 at 10:24 am

    #836246

    I know this is SQL 2000, but haven't gotten the red squiggly on 2005 yet that I am aware of. Notice the agent does not have a clock on the icon.

    Is the clock new for 2005?

  • June 30, 2008 at 11:39 am

    #836284

    I just looked at every server I've got. I looked at all of them in Management Studio, and also looked at the 2000 ones in Enterprise Manager. All of the Server Agents had a clock on them, even the SQL 2000 copies in EM.

    I'm going to hazard a guess that the change in icon means something is wrong, and the red squiggly is trying to tell you to look for what's wrong.

    It's possible that right-clicking Agent on that server will give you more data. I'm not sure. I don't think I've ever run into that one before. I'd definitely start from the assumption that SQL Server is trying to tell you something is broken. (Somehow, I don't think it's asking for red licorice, if you know what I mean.)

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • June 30, 2008 at 12:15 pm

    #836305

    First, let me apologize. That screen shot is from a SQL 7 instance. Upgrading it to 2005 in July. Actually have another post in the other newbie forum about it just to make sure I am going to be doing it right 🙂

    I checked some more SQL server 2000 instances and all the agents had the clock. Maybe that icon change was from version 7 to 2000.

    I right clicked on it and could not find anything in particular that would suggest something was wrong. I am fairly certain I have seen the red squiggly on instances of 2000 though.

  • July 1, 2008 at 8:42 am

    #836733

    Ah. I don't have any SQL 7 instances. That would explain why I'm not familiar with those.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • January 26, 2010 at 9:55 am

    #1108783

    That red "squiggle" in SQL 7 means you are connected.

  • January 26, 2010 at 10:56 am

    #1108827

    Wow...you must of been looking for something particular to go back so far for a thread 🙂

    Thanks for the response though! 🙂

  • January 26, 2010 at 11:00 am

    #1108829

    ROFL - you're right! :w00t: didn't even look at that date! np

Viewing 9 posts - 1 through 8 (of 8 total)

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