Hi Lowell,

Thanks for your prompt response.

Unfortunately that doesn't look like the issue I'm experiencing. I have narrowed it down to the query below.

declare @IndexServerRes table (path varchar(500) primary key,rank float)

insert...

Hi thanks for the replies. Schemas aren't really an issue as they're not in use, I will have a play with the script and see how I get on. Regarding...

Thanks and well done too.

A few years ago whilst working for a Managed Services company I signed up for an apprenticeship scheme run by a training company. If I passed...

I passed this last friday. 48 questions though I suspect some of them where none scoring as one related to SSRS. I found this harder than the 431 but...

Cheers Steve, I have tested Clustering within Virtual Server. The main client which is interested in this has the budget for clustering but seem to lean more towards mirroring. I...

Sorry Steve, perhaps I didn't explain myself properly. I'm trying to find a way to connect are client software to multiple mirrored databases, with as little additional development as possible....

Fair enough, guess I didn't read that properly. Not that I new that...

🙂

Glad to hear you got your problem sorted. If I understood it correctly you could have changed the SQLS Server Service startup parameters within SQL Server Configuration Manager and pointed...

As above, zipping sounds like your best plan. Bak files will compress a fair bit.

Hi Mazzz,

I shall be heading up from Nottingham to check it out. Still a beginner myself, only just passed my 70-431 yesterday. Not too sure which sessions I'm...

As far as I am aware the instance can only have one mirroring endpoint and can in turn only witness one partnership.

Can anyone else confirm this?