lucassouzace (1/9/2009)
What´s Diference between SUSER_SNAME and APP_NAME using Resource Governor?
SUser_Sname returns the user's login name. App_name returns the application that initiated the connection to SQL. In terms of the resource governor, one lets you limit resource based on who's logged in, the other lets you limit resources based on what they used to connect (a 3rd part app, Management Studio, SQLCMD, etc)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability