You the man!!!

Nice one worked a treat.

LinkedServerName.Catalog.Schema.TableName

What is the default schema of a 4 part qualifier name for a MYSQL table?

SDK CLIENT TOOLS

BACKWARD COMPATABILITY

ETC ETC got it.

Bringing this up again.

Is it as I have suggested below.

2 Types of always on

FCI and AO Groups

FCI, modification of clustering which already exists, needs shared storeage or can use Shared...

Nice one. Thought there was more to it.

Cheers folks, Chris I will post mo. info in future.

I found my bad data, they sem ti be prefixed with '£'.

How do I remove all of these characters from the row.

LTRIM?

Nice one, I'll go with the changes that brought the LReads to 611.

Cheers

Ok Gail. Thanks I thought that would be the case but nice to have it confirmed.

Regards

Rob

Thanks both of you I'll try it tomorrow.

Do you have any jobs that are failing where the job owner is 'sa'

Found the solution, In the db under STORAGE find the CATALOG then right click script as will produce the folder location in the script.

Still no indication of where the folder is that the FTI is using.

How do I see where the FULL TEXT CATALOG is for a specific db. None of the DMVs here are useful http://msdn.microsoft.com/en-us/library/ms174971.aspx

Thanks, I did try that I must of been doing something wrong with the server name.

I'll try again.