Answered by:
What is the signifigance of the user Icon in SSMS DB users node with the red down arrow?

Question
-
SQL BOL documentation is sorely lacking in this area, or I just haven't found the magic words to find such explinations. It amazes me when developers come up with a "cool new icon" to signify something and then don't bother documenting what the heck it means!
So, in general, has anyone found a CENTRAL reference of icon descriptions for SSMS?
Answers
-
Dwaine,
You may want to drop a note to the SQL Server Team at: https://connect.microsoft.com/SQLServer?wa=wsignin1.0
User Red Arrow down means Login Disabled.
(partial answer)
Execution plan icon link: Graphical Execution Plan Icons (SQL Server)
Kalman Toth
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016
- Proposed as answer by Alex Feng (SQL)Moderator Tuesday, November 10, 2009 11:50 AM
- Marked as answer by Alex Feng (SQL)Moderator Monday, November 16, 2009 10:24 AM
- Edited by Kalman TothEditor Friday, November 10, 2017 1:31 PM
All replies
-
Dwaine,
You may want to drop a note to the SQL Server Team at: https://connect.microsoft.com/SQLServer?wa=wsignin1.0
User Red Arrow down means Login Disabled.
(partial answer)
Execution plan icon link: Graphical Execution Plan Icons (SQL Server)
Kalman Toth
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016
- Proposed as answer by Alex Feng (SQL)Moderator Tuesday, November 10, 2009 11:50 AM
- Marked as answer by Alex Feng (SQL)Moderator Monday, November 16, 2009 10:24 AM
- Edited by Kalman TothEditor Friday, November 10, 2017 1:31 PM
-
Just as a clarification, a login with a red arrow down is a disabled login, and a user inside a database with an red arrow down is one that does not have CONNECT rights to the database. This can be fixed with the following grant statement:
USE DatabaseName GO GRANT CONNECT TO [Username]
-