Ahhhh, thanks Andrew, I'm a big dummy and overlooked the 32bit config.

Thanks!

Hey all, still haven't had any luck on this ... hoping to catch someone's attention on this.

Thanks

You can only return one recordset with SSRS. You'd be better off writing your own view/proc to accomplish your needs.

Mani Singh (6/26/2009)

---

if varchar will be faster than nvarchar.. but further, if you can reduce their sizes from default varchaR(50) to a specific length as required by the data, you...

Is the query you're running doing something that is not supported in 2005? Can you manually run the script against an '05 instance without issue? You can most definitely register...

SP3 also has up to CU4 now released ...

Have you checked to see if it's already installed?

SELECT SERVERPROPERTY('ProductLevel')

Response after mine was better 🙂

Indeed. Sorry, I hate people who don't post in the right forums, but I hang out primarily in the 2005 forums and it gets alot more traffic. Wish they'd merge...

Is it an NT account? Have you checked for the conflicker worm? If not, do they have fat fingers? 🙂

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 1, page ID (1:15). The PageId in the page header = (0:0).

CHECKDB found 0 allocation errors...

see above, removed

Just redid it as a sp_send_dbmail step with @file_attachments.

Still curious to as why this doesn't work though.

How much memory do you want SQL to use? SQL is an animal and will consume whatever you allow it to ... You can give it more than what it's...

Looks like both of these are known and resolved in CU's post SP4 ... May engage M$, but will more than likely get the latest hot fix and apply appropriately.