I suggest also running

dbcc useroptions on the database(s) the report points to.

This will let you know for sure the language setting used on the target.

Regards.

"But something like "amount of purchases last 12 Month" < 6 might be useful, and categories might mess this up "

A good point but it still all fits. If the...

Hi - to answer your question, create a domain admin account on your network if you haven't done so already. Use this same account to run the Agent service on...

I suppose create a trace in profiler to see what connections to your database are coming from other servers and using the account that ssrs is running under. If the...

One reason I think this is not a good practice is that the cardinality can be quite high. This can be valid to do if business regards this as important....

It is suggested you use a single domain account for all SQL server agents, a domain admin to allow access to share folders. Make sure it has 'log on as...

Do dbcc useroptions to see what lanugage you are using. Us_English will recognize 10-11-12 as Oct 11 2012. But British English will see it as Nov 10.

From here do...

Great article and imagination, about all I would suggest is toward the end of the trigger ...

FROM

WHERE Content IS NOT NULL

...

You'll need MS DTC running if you are using 'immediate updating' updateable subscriptions. The other option is 'queued updating.' Here the changes are stored at the client and pushed when...

One thing I saw on MSDN and worth noting:

"Because the leaf level of a clustered index and the data pages are the same by definition, creating a clustered index and...

THis is not the cleanest way but for those who dont have the lookup functionality in SSRS...if you can import the data to the current database using a temp table...

Your database login may have a default language different than English, or the production server's default language may not not match the one to your login. Maybe the agent for...

Surrogate keys are a great way to keep track of multiple instances of the same entity (product, person, ...). You can add a validFrom and validTo date fields to also...

Is it possible there is replication whereby both updates need to occurr at the same time (publisher / subscriber) ? If so there could be an issue on the other...

To create a database user account for an existing login,

sp_grantdbaccess @loginname = 'loginname'