When I start SQL Server Management Studio 2008, I an error that's been around forever and is documented here. One of the suggestions to fix it that actually worked was to start SSMS with Run as Administrator.
So I modified the properties of the shortcut to always run it as the administrator. The only annoyance is that I get a prompt every single time asking whether I really want to do it.
Is there a way to tell just this one program (SSMS) to not pop up the prompt, while keeping this behavior for other apps?