Thanks Mark

That works great!

SELECT WITH CASE WHEN END THEN ELSE JOIN WHERE GROUP AS ORDER1 the word ORDERonitsown causes the failure

ok is it special characters () <> * = + - dbo.Table

this is really annoying I cant post any code this is to see if its just the length of post thats failing blah blah blah blah blah blah blah blah...

Thanks skcadavre

I'm currently working on a CTE to identify the colour change condition

Anyone having difficulty posting/previewing with IFCode

I'm getting in IE 'cannot display webpage'

and Firefox 'the Connection was reset'

I can post without IFCode fine

I'm currently a .NET developer - but my focus tends to oscillate between C# and SQL Server.

In my current company the DBAs are the gatekeepers to SQL server - some...

A Site Owner doing his job

http://videosift.com/video/The-Cleaner-Arrives-La-Femme-Nikita

Before or after you mentioned the 'Site Owners'...

Mendelssohn

On my Windows 2003 machine PAE was set up automatically after I changed the DEP setting in BIOS.

Not sure if this applies to windows 2008, http://msdn.microsoft.com/en-us/library/aa366796(VS.85).aspx but it may help.

You may need to enable memory over 4Gb in Windows

Look up physical address extension (PAE) and Data Execution Prevention (DEP) - I know I had a 2003 server machine that...

CirquedeSQLeil (3/24/2010)

---

Tom Brown (3/24/2010)

---

Paul White NZ (3/24/2010)

---

Tom Brown (3/24/2010)

---

Finally put IE out of its misery after it had swallowed 1.5Gb and showed no sign of return after 5...

Paul White NZ (3/24/2010)

---

Is that not normal...

Warning: Don't try this you'll be in for a long wait.

Just experimenting with the various options + settings and I tried "Display Mode" -> "Threaded" on this thread.

Bad...