If the logs didn't get restored, they wouldn't be there. Sometimes people delay logs by time, so check that first.

If log shipping is running, the changes move. No way they...

I'd agree with Jason. If you just want to get data onto the web, SSRS is probably the easiest thing to do.

I mostly do this for Grant's reasons, but nice catch Elliot on missing rows in the second table.

OLAP, SSRS is just a tool. To do web based analytics, you need a web application that allows you to access data. There are tools that can do this, or...

rerun setup. There's an option to install client tools.

What are you worried about? You are doing a backup and restore. The DDL is the same, or it is once the secondary has caught up to the primary.

You can...

Can what be a simple thing like Excel? I'm not sure you've defined the problem you have very well.

Submit it here: http://www.sqlservercentral.com/Contributions/Home

We'll help you rewrite/draft it. Some notes here as well: http://www.sqlservercentral.com/About/WriteForUs

LOL, it wouldn't be quick if I were at TechEd. I only have a couple times a day I check things. Back home today.

The article would be short, but it...

Any suggestions from South Africa? Something from Cricket, Soccer, etc?

Post us a script, or send me an article, MG, when you get it working. That is something others can use.

Good suggestions. I'll think about adding them in.

I'd agree with BT. If you're not explicitly closing connections, and maybe don't have connection pooling, you could get this behavior.

Whoever has Cutler can keep him.

I just can't see women playing football. I played rugby in college, and the women's team was a whole different game. The level of violence...

Yep, sorry, 200 bytes.

It's always work, and on smaller systems, small tables, it's not enough with lots of hardware to matter. But it raises the level to which you system...