Thanks but I need the duplicates filtered or it will make a mess of the results for some items.

Thanks I will take a look.

thanks didn't even register that they were left over from typing text in manually to test.

after running the allow updates to zero I get this

Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

Msg 5845, Level 16, State 1, Line...

here you go.

I actually did just download the free one 🙂 got a nice new production printer that we needed to test out so 400 pages should do...

I am part of the Sysadmin group, your talking about under Security then servers roles we have a sysadmin group and I am part of that.

I Tried running each one separate and all of them together and they give the same errors see attached. Maybe I have something wrong.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51

The configuration option 'min server memory (MB)' does not exist, or it may be an advanced option.

Same on the max

I assume...

first command I am getting this

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Msg 5808, Level 16, State 1, Line 2

Ad hoc update...

Keith:

Sorry As I reread this it is a bit fuzzy

We have a Sql Server running Server 2003 Std X64 SP2, On this we have a Microsoft SQL Server 2008...

Much like other things on the internet there are many different points of of view

http://sqlblog.com/blogs/argenis_fernandez/archive/2012/12/30/the-myth-around-32-bit-sql-server-instances-on-64-bit-operating-systems-and-awe.aspx

Michael L John (4/14/2014)

If this is a 64 bit machine, what did you...

Its been at 3.8 since we turned on AWE so I doubt that any Microsoft product could do that :). It looks like a hard stop. Its hit the 4...

I found the parts that are messing it up, just now need to find out how to fix them. will post once I find it.

thanks Sean I will take a look at those.

I have removed the UDF call as a test to see and still slow just as an FYI.