Hi Jeff,

Hmm, no. I don't see a partial/partition copy to a different server a requirement.

I did consider being able to swap a partition out to an archive database but I...

Could you disable the login(s) during 'processing' ?

That's what we do here to stop users logging in when we're performing a nightly bulk load - the users tend to get...

Just to add - as it stands, I've resorted to killing off any SLEEPING sessions, after business hours, and if the session is > 2 hours old. Business hours stop...

Thanks Durai.

It says, if I Am reading it correctly and not missing something that the reports service needs to be restarted.

Is there a way I can achieve this without needing...

Cheers Roshan;

So the locking DOES start from the beginning of the search? Or only after it has located the rows?

Cheers Gail. Yeah I wasn't going to remove them as I presume they were added to fix something.

But it appears to be either bad design, or the product has grown...

Ah right, thanks all, appreciate the details and the warnings.

I wasn't going to apply all the suggestions (there are over 300) but there were two that made sense. One of...

Perry, would you mind elaborating a little on your last comment in this thread.

Regarding the quorum model, and choosing carefully.

Or point to a good reference...

Cheers

Alex

Perfect! Cheers Kevin.

Alex

Hi Lowell,

I very much like your trigger! I've saved that into my collection 🙂

My only concern is because it's modying an existing object, its going to need to go through...

Thanks Both.

That is both a shame and annoying! Never mind... Drawing board beckons.

Cheers

Alex

Just to update and close this thread for any others reading:

This was solved simply by bringing the database online with alter database!

Pretty annoyed that I did't try that first before...

Hi All,

Just to update and thus complete this thread for other who might be reading. I did the upgrade as discussed further up and also referenced in the link.

I had...

Oh, sorry forgot to add - upgrading because at some point it is going to be revived, made writable and brought into production - in an AG.

Nothing else. Quite literally just the database.

It should, on paper be easy - but have caused quite a challenge by applying SP4 🙁