Hi,

I'm actually trying to resolve a Report Builder 3 problem, in that the date formats are coming through in a US format but we want them to come back in...

Hi Gail,

Thanks for the correction on the server sessions.

All the regional settings in the O/S say that it is in 'UK mode' which is what we want. I'm at a...

Hi,

If I understand this correctly though this would change the dates for only this report.

When Report Builder 3 loads up it is reverting to a US date format, there must...

After a bit of thought I concluded this must be ok or you would never be able to update your development and UAT environments.

I successfully removed the key and everything...

Hi,

Thanks for the responses. Sadly there aren't any patterns, no signs of blocks, excessive server load etc.

I'm currently trying to go through the wait stats to figure out exactly what...

Thanks for the replies.

Looks like I'll have to do the full restore at least once to allow the upgrade then. The database is large but I should be able to...

It took me two cups of tea and a little brain power but I got it right!

Nice question by the way, thank you.

Hi all,

Thanks for your responses, since the lines in our case are to be the same length we achieved this without to much complexity.

Thank you all for your help.

Nic

Hi Nick,

Yes and this works, but it means for every new report created they will have to do this.

Ideally I wanted to be able to set it at the server...

Hi,

Got it, the account had the correct SPN's however the machine also had two additional SPN's (which should have been for the user).

So setspn -L <user> was correct but...

No, this is where I get's fun.

It was running as local system, then we changed it to run as a domain account, the services started but when I tried to...

Hi,

Thanks for the link. It's useful tool. It is reporting that there are duplicates (see attachment). The first line is the server name, the second line is with the port...

Hi,

I managed to get this done by using sys.database_files.

In my scenario each partition was represented by 1 file group so in the table it shows them as 'RECOVERY_PENDING' if they...

Hi Jeff,

The behaviour is a little different on my development instance (SQL 2012 SP1).

In that instance I have a database with 5 file groups;

PRIMARY - Primary file group.

FSPre2014 - holds...

Hi Jeff,

Thanks for the reply.

Each partition sits on it's own filegroup, so in essence I just need a method to determine if the partition or the filegroup is online.

Any help...