I have several subscriptions on R2 that seem to get stuck in the Pending status - but the reports have been created. This is one of the weaknesses of...

We run reporting services on our web server which is a separate box from our db server. Look at for details about scaled out deployments.

MWise

Are you writing your own web front end with the report viewer control in it? If so, you set the report server url to your reporting services server (

I've attended several of Pragmatic Work's free SSRS webinars and have found them to be really well done. However a quick search shows no SSRS 2005 classes. If...

If you can't add a distribution list to your email system, you can add multiple email addresses in the Email Name field for an Operator - just separate them with...

You can use policies to check for TDE. Use the EncryptionEnabled property of the database facet. You won't be able to use this to prevent someone from not...

We've had to use cursors in generating notification emails using sp_send_dbmail. We have a list of 5 account execs that get notified when their data is loaded and ready...

You should be able to limit the access to read only of the tables you need to build your cube.

You should first double check that you have the correct dataset or group name typed in correctly, the scope name is case sensitive. I've tested a tablix of mine...

We store our XML config files in a specific folder that is locked down via AD to our admin group. That keeps the passwords out of the packages and...

You could create a report subscription for each report and save to file share as PDF. If you have Enterprise Edition, you can set up a data driven subscription...

I assumed that the question was referring to backup compression, not page or row compression. I think the question would be more clear if the terminology of "page compression"...

I'll probably take 70-433 next. When I purchased the online training for 70-432 the 70-433 sessions were included in the price. Plus I actually find the code writing...

The MS Press Test Kit book comes with an evaluation edition of SQL 2008 which includes all of the features that you can be tested on. I believe it...

Re Transcender breaking NDA - I don't believe this is true anymore. They are now owned by Kaplan and show as safe from CertGuard.com. I've been using them...