James,

That thought did occur to me (constructing the SELECT execution string dynamically in the SP), but it seemed to me to not be any better than doing the same thing...

Never mind about telling me about the difference between simple, full and bulk logging.  I looked it up.

More important, in a production environment, is full or bulk logging to be...

OK, that did the trick, Lynn, but what exactly does setting the recover mode to simple do?

And I've noticed that some of the other databases, that aren't giving me any...

We have a problem now, not with SQL Server or any other database, but with our reporting engine.  We use Crystal Reports on our server to generate reports in an...

Man, Steve, I want your job! 

That is correct zzx375, it looks to me as though Reporting Services doesn't support print subscriptions.

Yes, I have 2 records with ProviderNumber = 105; but that is because ProviderNumber and Facility together comprise the primary key. 

Like Ninja said, my problem was an update trigger...

Ninja's,

I had not thought of a trigger.  Good idea!  I found triggers, one involved with updating the table.  It is a long trigger, written back in 1998 by a developer...

A good article, Janet!  I've had bad managers, and good managers.  I realize that I probably haven't has managers as bad as your ugly managers.

One comment; I think the influences...

Steve,

Who does your wife work for?  4 weeks vacation!  Fantastic!!!

I'll be taking off time starting next Wednesday (the 13^th) and going through until January 2^nd.  I'm looking forward to it,...

Hi Lisa,

I'll try to be clearer.  The ASP.NET application is on our web server, and that server is the only server outside of our firewall, so that it might be...

I've got a follow-up question about this. The ASP.NET application uses SSL, and the Reporting Services report is on a different server, behind our forewall. When I ran the report from home...

Hello Lisa,

OK, I've been experimenting and I am really not getting this.  It might be best if I work through an example.

Let's suppose my report is called ProviderData.  It has...

Ray,

So, what you're saying is taht all Reporting Services reports get published to http://servername/reportserver, so that they can be run from http://servername/reports, correct?

And if I may ask another...

Ninja's,

I got the error when I attempted to open (view) the job history.  I've no idea if it is in the history or not.