Thanks for the information, Pam. I will take your advice and purchase a book on administration.

Thanks, Pam.

I hope that I didn't come across as being impatient. I really wasn't, and I appreciate the help I receive here.

To answer your questions.

What is/are the recovery model(s)...

Will anyone answer this?

Thanks, Leo.

One more question.

I have these steps for my user database maintenance plan:

1. Check Database Integrity

2. Reorganize Index

3. Rebuild Index

4. Update Statistics

5. Clean Up History

6....

Thanks, James.

Thank you all for your replies.

We are considering upgrading to get additional features.

What prompted my question was that I recall reading somewhere that an upgrade to enterprise will require purchasing...

Hi Si,

Will you give some detail on how to use the .render method as you describe?

Yes, it's possible.

Drop a ReportViewer control onto you web page or form.

Here is the code I use in asp.net:

this.ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;

this.ReportViewer1.ServerReport.ReportServerUrl = new Uri("Your URL for the report server");

this.ReportViewer1.ServerReport.ReportPath =...

Well Junkie...I feel real stupid now for asking.

Thanks!

Hi Chip,

I recently worked through the same issue that you are now facing.

What I did was set the credentials (a valid windows account) in the web page.

See below:

Me.ReportViewer1.ServerReport.ReportServerCredentials = New...

Thanks, Steve. Very helpful.

Thanks, Robert. I thought I tried that format.

Thanks, Adam for an excellent explanation.

Thanks, Adam.

There is no transaction running.

I've read that shrinking a database is not a good thing to do.

Does dbcc shrinkfile shrink the database?

Would I just issue the 'dbcc shrinkfile' command...

Thanks, thierry.

I'm using the standard edition of SQL Server.

I will look into using the driver you use.