Sunday, November 08, 2009 6:25 PM
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?
Sunday, November 08, 2009 11:26 PMAnswerer
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.
Execution plan icon link: Graphical Execution Plan Icons (SQL Server)
- 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 TothMicrosoft Community Contributor, Editor Tuesday, October 02, 2012 11:29 PM
Thursday, November 25, 2010 10:19 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]