weird issue? green arrow disappear

Question

weird issue? green arrow disappear

bissagars

Mr or Mrs. 500

Points: 555
More actions
July 18, 2018 at 11:04 am

#407206

I have been using SQL Server 2008 SP2 for 2 years and didn't face that, today I upgraded to SP4 and noticed weird thing.
If I try to add a job and refresh the SSMS explorer , the green arrow will disappear but everything is working fine. Jobs are running and didn't notice any malfunctions.
I have to re-open new SSMS connection and green arrow is back
I have administrator privileges

Viewing 7 posts - 1 through 6 (of 6 total)

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

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 1

bissagars - Wednesday, July 18, 2018 11:04 AM
I have been using SQL Server 2008 SP2 for 2 years and didn't face that, today I upgraded to SP4 and noticed weird thing.
If I try to add a job and refresh the SSMS explorer , the green arrow will disappear but everything is working fine. Jobs are running and didn't notice any malfunctions.
I have to re-open new SSMS connection and green arrow is back
I have administrator privileges

It's not a fault.... it's a "feature". It means that if want to do certain things, you'll need to "Run as Administrator" to do them. For example, attaching MDF and LDF files to attach a previous detached database. Same holds true for SQL Server Agent. Unless you "Run as Administrator" to get into SSMS, you might not be able to (for example) shut down the SQL Server Agent from SSMS.

--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.

Change is inevitable... Change for the better is not.

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

bissagars Mr or Mrs. 500 Points: 555 More actions · Answer 2

Jeff Moden - Wednesday, July 18, 2018 11:07 AM
It's not a fault.... it's a "feature". It means that if want to do certain things, you'll need to "Run as Administrator" to do them. For example, attaching MDF and LDF files to attach a previous detached database. Same holds true for SQL Server Agent. Unless you "Run as Administrator" to get into SSMS, you might not be able to (for example) shut down the SQL Server Agent from SSMS.

I am already running the server as Administrator

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 3

bissagars - Wednesday, July 18, 2018 11:15 AM
Jeff Moden - Wednesday, July 18, 2018 11:07 AM
It's not a fault.... it's a "feature". It means that if want to do certain things, you'll need to "Run as Administrator" to do them. For example, attaching MDF and LDF files to attach a previous detached database. Same holds true for SQL Server Agent. Unless you "Run as Administrator" to get into SSMS, you might not be able to (for example) shut down the SQL Server Agent from SSMS.
I am already running the server as Administrator

I don't mean as a sys_admin. I mean for how you start SSMS. If you right click on the SSMS icon to start it, you see an entry for "Run as Administrator". That's what I'm talking about.

--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.

Change is inevitable... Change for the better is not.

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

bissagars Mr or Mrs. 500 Points: 555 More actions · Answer 4

Jeff Moden - Wednesday, July 18, 2018 11:25 AM
bissagars - Wednesday, July 18, 2018 11:15 AM
Jeff Moden - Wednesday, July 18, 2018 11:07 AM
It's not a fault.... it's a "feature". It means that if want to do certain things, you'll need to "Run as Administrator" to do them. For example, attaching MDF and LDF files to attach a previous detached database. Same holds true for SQL Server Agent. Unless you "Run as Administrator" to get into SSMS, you might not be able to (for example) shut down the SQL Server Agent from SSMS.
I am already running the server as Administrator
I don't mean as a sys_admin. I mean for how you start SSMS. If you right click on the SSMS icon to start it, you see an entry for "Run as Administrator". That's what I'm talking about.

I tried to run the SSMS as Administrator, it is the same. Please take a look on this video.

https://youtu.be/uw3Um6cl_sQ

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 5

Dunno then. I've not had nor have been able to duplicate that problem if running as administrator.

--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.

Change is inevitable... Change for the better is not.

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

bissagars Mr or Mrs. 500 Points: 555 More actions · Answer 6

I just tried the new SSMS V17, and I can't duplicate the issue with the new SSMS.
So maybe a bug with the old SSMS supplied with the SP4 update, not sure but I can duplicate the issue on different servers if using the old SSMS.