Gift, et al,

Last night I tried putting the SQL Server DVD into my laptop, being certain that IIS was now installed, but when I tried to put Reporting Services on,...

Gift, I've installed IIS after I realized my mistake.  Would that be sufficient in order to install Reporting Services now?

Dick, that is possible, I suppose.  I hadn't checked the file properties before I started, and now, just looking at it, I see that there is a file size restriction...

Thank you, jezemine and SRB.

Andy, that is interesting.  At our user group discussion is always at the end.  In fact, at every user group I've ever attended, discussion was always at the end.  How...

Last year was the first time I ever heard of a code camp, and it really captured my imagination.  I work in a small development group (OK, one other guy,...

I don't think that computer science degrees are dead, but I do think they are "sick" (to extend the metaphor).  I think most people entering college today are sensitive to...

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...