you need to change the user that your application is running under. see samples: User Impersonation in .NET[^] http://stackoverflow.com/questions/1168571/run-code-as-a-different-user-c[^] http://stackoverflow.com/questions/125341/how-do-you-do-impersonation-in-net/7250145#7250145[^]

If you want to excecute your query on every 31st December add a below condition IF (MONTH(GETDATE()) = 6 AND DAY(GETDATE()) = 16) BEGIN --Write down your query END