Cool, I was able to fix it by making everything the same width and moving the report to as close to 0,0 as I could. I also deleted one...

Ok thanks, I will give that a try.

bumping this again, still have not found a resolution.

We went from a 32bit/32bit SQL 2000 environment last year to initially, a 32bit SQL /64 bit OS enviornment. It was not ideal. The server was constantly at...

bump.

hodo (11/17/2010)

---

I checked your spQueryAD procedure and it's the same version I use successfully.

I noticed I get the exact same error if I just run a simple query trying to...

Cool thanks again, I actually edited my post after I just used google to look up the answer to my question! 🙂 I didn't realize we had actually turned...

Cool thanks some good advice.

So, I've changed my memory usage to 6Gigs

I've changed the paralellism to 0

I just kicked off a query that is pretty simplistic:

select top 10 * from...

LutzM (12/2/2010)

---

Here are the ones I'm concerned about:

max degree of parallelism1

Are you sure to prevent parallel processing on the server level? Is the server mainly used for OLAP or OLTP...

Yes, it is dedicated to SQL. When we had first set the server up we had some crazy performance issues because I didn't have any value set in there,...

I have a couple more questions and maybe I'm just not understanding the problem totally...

Lets say person A moves into your building A on 12/15/2010.

On 12/31/2010 - You want to...

Thanks, I will give that a try when I get some time.

Also question, does AD 2008 fix the 1000 record limitation issue? Or is it still present? I...

Still nobody? Is my question ambiguous? If I need to clarify anything to get some responses, please let me know.

Hi guys, still need help with this... had to shelf the process for our release cause I couldn't figure it out. Don't any of you pull active directory info...

Cool thank you so much. I've been a developer for many years so getting into the more admin type stuff is new for me. 🙂

Thanks to everyone for the...