Grant Fritchey (1/2/2014)
The application name is a connection string bit of information that you can put anything in. You could say "Bob" for the application and SQL Server wouldn't know what you're connecting from. So, it really doesn't narrow it down at all that it says "Management Studio."
Sorry Grant, in full it says Microsoft SQL Server Management Studio (not with - Query btw), so could that be an automated maintenance task like I suspect or would only SSMS connections have this?
possibly I am not following...
'Only he who wanders finds new paths'