« Cumulative update packages for SQL Server 2008
SQL Server 2012 RTM sample databases »

How to change the locale of a report subscription

I'm working on a script (utilizing rs.exe scripting tool), that saves subscriptions from report server and allows creating the subscriptions on a different server.

Everything works fine except a problem with subscription locale. The problem is that when the script attempts to create a subscription, it does not know which locale to use and may fail on format of parameters (especially date parameters). There is no parameter for the local, when creating a report, but you can update the subscription later on. The symptom using a foreign language for email-subscriptions can be a different format for the subject line, too. You can see

  • "... wurde zum Zeitpunkt '3/19/2012 9:15:10 AM' ausgeführt."
  • instead of "wurde zum Zeitpunkt '19.03.2012 09:15:10' ausgeführt.".
Here is the script to update all subscriptions to a german locale:

UPDATE [ReportServer].[dbo].[Subscriptions]
  SET Locale = 'de-DE'
  WHERE Locale = 'en-US';
reporting
SQL Server
 Print article This entry was posted by cmu on 2012-03-19 at 09:51:00 . Follow any responses to this post through RSS 2.0.