From: esquel@sommarskog.se   
      
   Carnefrisca (jova.xNOSPAM@tin.it) writes:   
   > is possible to change the first day of week on sql srv or AS?   
   > actually, if i use the sql query "Select @@DATEFIRST" i see the day 7 of   
   > the week...   
   > if i want to change it to 5, there is a way to do this?   
   >   
   > (i've tried "SET Datefirst 5" but after e restart i lose the setting)   
      
   Yes and no. You can set the default language for a login, and also the   
   default language for new logins, and the language controls the default   
   for the DATEFIRST setting. However, there is no language for which the   
   default datefirst is 5, only 1 and 7 are in use.   
      
   Judging from your e-mail adress, Italian would be the logical choice of   
   language, in which case you will get 1 for @@datefirst. Not that this   
   will also affect how date literals are interpreted.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)