But I don't get the error - wouldn't I get the error too if it was a compatibility issue?

The user who is getting the error appears to have never got...

Sorry not sure I understand you comment.

The server is Windows Server 2008 and SQL Server Management Studio information is below -

Microsoft SQL Server Management Studio - 9.00.4035.00

Microsoft Analysis Services...

Thanks guys for the help so far.

I've discovered that what I thought was a potential link actually isn't so after all your advice it's not going to help me in...

Thank you very much. Just what I was after.

Hi,

I've exported all the dates and can't see an issue with any of them by running the following part of the script -

SELECT TEN.[tenancy-ref]

,loc.[place-ref]

,ten.[tncy-end]

,MAX(DIA.[CRT-DATE]) AS 'Actual Terminated...

Sorry John.

Thank you very much.

Thanks John,

Definately on the right track now -

changed it slightly to -

ROW_NUMBER() OVER (PARTITION BY LOC.[place-ref] ORDER BY TEN.[TNCY-START]) RowNo

It will now increment the RowNo if...

Ahhhh for goodness sake.

Copying and pasting the UNC path would go to the location, so I thought nothing of that.

As you have spotted the database name as a space at...

Ahhh I see, I thought it was just the agent that needed access. I will changed the SQL Server Service to also use this account (but will have to do...

When I'm also logged on the management studio and I run the TSQL on the following (logged on as sql2008 user) and I run this code -

EXECUTE master.dbo.xp_create_subdir N'\\mhsmgmt01\SQL...

Legend. Thanks Phil

Got it working -

CONCAT (TEN.[tncy-sys-ref],CASE WHEN PER.[GENDER] = 'M' THEN '1'

WHEN PER.[GENDER] =...

Thanks for the reply. That's not working I'm afraid.

It's still increasing the TEN.[tncy-sys-ref] by 1 or 2 as opposed to just concatenating a 1 or a 2 at the...

Looks like it's linked to my Rebuild Index Task.

Everytime I run it - the database balloons in size.

Via the GUI I have the Change Free space per page to...

So - I've got it working with some help here -

This may be the long way round of doing it - but I've left the Transaction Date and Transaction Time...