"LOL, so there are two of us then"

You should see my husband's face when he brings my morning coffee and there I am jibbering on about SQL Server agents, code...

liebesiech (8/6/2010)

---

Interesting question! Well, I get my ideas when I'm not thinking of having an idea. Best place is in the morning under the shower. Then I'm in this state...

Sorry that I have not been in touch but I have been off ill.

I managed to load SQL Server 2008 R2 from the cd which was fine on the evaluation...

I have located an original Microsoft disc so I am going to try with that later today. It would appear that the downloads are rubbish. I will keep...

It was downloaded from the Microsoft site. We have an licensing agreement

Reminds me of a friend who was discussing a colleague. The colleague was supposed to have 10 years teaching experience. My friend maintained that she had one year's...

No really unless I want to stir up a hornet's nest. The true knowledge dbas of this database are an outside company (the database will become redundant in the...

Sorry I do not have SQL Plus. I do not use Oracle at all; this is a 'heritage' database

I have tried to add another field and I get exactly the same error message. Are we getting somewhere (hopefully!)?

I tried just adding the semi-colon but got the same error. I tried just adding the field with and without the semi colon but got the same error.

I tried...

When I copied and pasted your code into the query I got the same error. When I added the item and added the comma and semi colon at the...

Well I am off to Sharm El Sheikh in May and I cannot wait!! In the meantime we do have to do some painting............ Don't Look Ethel

Just because I am paraniod does not mean that they are not after me. And yes, I have been doing this job for more years than I care to...

Henrico Bekker (3/18/2010)

---

Call me a bit too serious, but I wouldnt take my eyes off the screen if I were you.

The mere fact that you "expect" something to fail, says...

So is Swindon that bad that you differentiate between 'near' and 'in' ?