Home Forums SQL Server 2008 SQL Server 2008 - General Changing setting for first day of the week RE: Changing setting for first day of the week

  • October 22, 2012 at 7:09 am

    #1551361

    matt.gyton (10/22/2012)

    Hi Lowell,

    These are just standard SQL Agent Jobs being run on a schedule, so I'm assuming I could just change the default language setting for the login they are being run under (currently the SQL Agent Service account)?

    Would changing the default language for 'NT SERVICE\SQLSERVERAGENT' do this?

    Thanks

    i think so yes, but you'd have to test it. it would be better to change whatever script you are using to not be sensuitive to datefirst instead;

    can you explain what is not running or occuring correctly because of that setting?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!