So as the first is a DateTimeOffset...

Use powershell, do a check on the service, if its UP, dont do anything, if its down run a script.

Do you have any columns in tables called Error or ErrorCode or something similar?

Yep thats the one, GPO is the culprit.

Ask your domain admin to create a particular GP for the computer in question to allow the account the nessesary access.

What is the icon to the side of the policy, 2 computers with a little script in the bottom left, or a torn page with 10010 on it?

Doh moment

LEFT("16",1) = 1 which doesnt match the value as that should go red, do left 2, so change it to CInt(REPLACE(LEFT(Fields!Field.Value,2)," ","")), that way if it picks "1 "...

You would just build that into your background expression as you have done

=IIF( CInt( Left(Fields!Runtime.Value,1)) >= 2,"Red","Transparent")

So for each forum ID, you want the number of hits, including the number of hits for any child forums.

488

5571

61463

92038

11128

1554

101065

8499

31184

13789

Could you not get left 1, convert it to int, then do > 2

CInt(Left(Fields!Field.Value,1)) > 2

Could you not format out in the data set an int based column which is used in the expression, but not shown in the report?

Ok what is the problem you are having with the code, it...

What function are you trying to remove?

The SUM?

I would of thought that Azure would come with the bulit in aggregating functions as standard.

http://msdn.microsoft.com/en-us/library/windowsazure/ee336248.aspx#aggregate

Azure does use the standard aggregating functions

Logshipping is basically doing backup and restore, so the same backup and restore rules apply, you can do it to the same version or a higher version.

But once you have...

You will need ISDATE(), LEN, CHARINDEX as a minumum to get this working.

But you should be doing your data validation in the front end, not within SQL.

Then you need to ensure that you setup transaction log backups otherwise the issue will keep happening.

Go back to the business and ask them what the recovery point objective is...