I want to employ people who take pride in their code. The sort of rubbish formatting that is so often posted on the forums would be an immediate "no" at...

We have postcodes in our database which only have the first "half", I expect that is not uncommon - i.e. the user was able to figure out / was given...

oneteabag (9/8/2015)

---

A New Monthly data is being loaded, checked and finally approved after 6 or 7 iteration before approval.

Because of this iteration the monthly data set is being added then...

I need to look into this further, but its a very helpful piece...

Very interesting, I enjoyed watching that, thanks. It reminded me that one of the other outcomes of a NOLOCK index read simultaneous with a page...

Thanks Gail. I have a real problem with "very unlikely" because my perception is that Business Users will make company-critical decisions on data that they see on their screen. ...

Follow up:

It turns out that the first step, un-setting the flag, took 7 minutes to run and a side effect was that all users connected to any [or so it...

Sorted!

I'm surprised I hadn't already tried that as its just the sort of cover-your-front,back-and-both-sides belt&braces that I normally go in for!

Reset back to zero and reconfigure took 7 minutes to...

HanShi (11/25/2013)

---

Open SSMS and navigate to the Management subtree.

Right click "Database Mail" and select "Configure Database Mail".

Click [next] on the (optional) welcome screen.

Make sure the option "Set up database mail...

P.S. Rechecked that Database Mail XPs is on, after the reboot. It seems to be:

name minimum ...

Thanks for your help.

My login...