I had a similar situation on my last gig. The client had a 4 way box with 8 gb of memory. Procedures on the production application suddenly began taking a...

yeah I'm considering it. I've been able to get the print to work okay from the report manager. It's just printing from the report designer stinks. Probably just my laptop.

Also,...

No. Brand new. Happened to start a new contract as sp2 came out so I started with a fresh sp2 install.

I tried adjusting the margins. Learned that right from the beginning when...

Steve

Totally agree and glad you brought this up. When I first heard about this I assumed that it might be part of an effort to reduce perceived TCO for SQL Server at smaller shops that rely on...

Nigel

Thanks for the reply. Be gald to post the execution plans but not sure the best way to do it. For now I'll pass along what I learned from an...

Well the trace helped alot. As I ran the sp, I noticed that in some cases the number of reads was significantly greater than in other cases. I tweaked and...

A profiler trace is a good idea. I 'll see if I can learn something from that.

Thanks

Michael

I include all of my headers in a header row in the table that contains the data and I have no problems. I add an extra header row then merge...

After several jobs failed again this last weekend (not just the ones I created), a little investigation work disclosed that the 605 error had occurred intermittantly as far back as March of this year....

Sean

I am a contractor working for a small company that uses sql server to support its ERP system and some other small applications. I've developed a data warehouse application that...

Yes, we are running an

HP MSA1000 disk controller.

Hopefully you have found a solution. What I have found in working with AS is as follows:

1. Make sure you have installe sp3 including the portion specifically for AS.

2. Make...

thank you

I took a quick look at the resource kit and without getting into a lot of detail it looks like there are several sample applications. Which one of these samples...

I'll definitely take a look. Have you developed reports for cubes using Reporting Services?