InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:50:30 GMT20http://www.sqlservercentral.com/Forums/Topic633798-391-1.aspxGood, thanks, could where make friends in sql server? because i'm brazilian understand? lately has study sql server 2008 and i haven't friends... but good for you my help, thanks!Fri, 09 Jan 2009 17:30:53 GMTlucassouzacehttp://www.sqlservercentral.com/Forums/Topic633798-391-1.aspx[quote][b]lucassouzace (1/9/2009)[/b][hr]What´s Diference between SUSER_SNAME and APP_NAME using Resource Governor?[/quote]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)Fri, 09 Jan 2009 13:10:36 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic633798-391-1.aspxWhat´s Diference between SUSER_SNAME and APP_NAME using Resource Governor?And this is statements:ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION= dbo.rgclassifier1);GOforALTER DATABASE Adventureworks WITH (STATE=ON)Thanks!!!Fri, 09 Jan 2009 12:56:31 GMTlucassouzace