Havent used Crystal in a while. I think when you start it up it offers some templates for different types of reports, you're looking for one that has a master/detail...

I've got one that is 15g or so. I'm very comfortable with SQL having large files in fact I prefer NOT to use filegroups, at least until I get to...

Yes, its a connection specific setting.

Andy

Looks like it is expecting 2 log files, you're only specifying one.

Andy

You'll see differing results in QA depending on whether you use grid or text mode (grid is faster), so if you tested in different setups that could account for it....

MSMQ is pretty neat, but I find that most of the time a table is good enough and one less thing to troubleshoot. I'm open to ideas about why I...

From looking at BOL it looks ok to me, but hopefully we can find someone who knows for sure!

Andy

I agree with David - even though you can treat Excel as an OLEDB data source doesn't mean you should! Not much extra work to get into a temp table.

Andy

...

The server is registered? Shows as started? If you try to start a service that is already running you'll get an error.

Andy

I would be surprised if it broke - you'd think any critical time would be stored as UTC, translated for display.

Andy

Bill, we use a scheduled job. You could use a trigger if it was low volume. Steve is right in saying that usually best not to run things on the...

Why would a cursor be the worst way? If you solve the problem as true set based operation I'd agree, but no matter how you rephrase it, you're really doing...

Bad query plan. Run sp_recompile sp name.

Andy

Yes, I read the email. I think you should just increase the timeout and let it run.

Andy

Sure. Leon is actually working on something very similar right now. What we ended up with is a "queue" table on the SQL box. Web server inserts records to process,...