Oh poo! Sorry, I've not done anyone any favors by posting in the way I have. I can confirm there are 9 columns, the example data below is per column...

Hi,

I should admit, at this time I don't even have the database or tables created! The data is in Excel and I was thinking of doing a straight forward tab...

Cluster config is correct and dependencies all correctly setup. The few databases that were set up correctly do have their logs in the R: drive already!

Thanks for the suggestion, however after trying that I am getting:

Server: Msg 5037, Level 16, State 1, Line 1

MODIFY FILE failed. Do not specify physical name.

Just googled the error and...

It's a bug!

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303292

This must have crept in with one of the Service Pack's because I know for a fact a standard Install does clear TRN's. The resolution is crap...

Yes I did.

Great, thanks a lot!

At least threaten to change ISP citing that your organisation cannot function without the relevent port. Might scare them.....I hate it when ISP's think they can control ports, especially when...

That'll do nicely....

Holy moly, I can't believe I made it sound like I have a table with identical columns!!! I'm so sorry, that was poor communication on my part.

Thanks Remi, I'm working on getting that to work for me.

My dupes are all in the same table so need to figure out the joins first. Ta

That'll work. ta

We all have our embarrasing moments and I think this is one of them. A case of trying to hard?

certainly.

All I did in the...

Did that at first but got [] symbols instead. Turns out, all you do is format the cells to "wrap text"

All solved!

Thank you...

Except it's not

Actually small booboo on my part. I was pasting straight into a selected cell rather than the formula bar for that...