The data is sorted in clustered index order, but this isn't the idea of SQL Server.

Are you thinking to edit data in SSMS? If so, you could move the clustered...

I'm with George. Nothing jumps out. The clocks shouldn't cause this, though you probably want them to get in synch. Could possibly be something there, but I'd think the job...

sp_helprevlogin is the procedure, but it's a 2005 one only now. They updated it. The original for 7/2000 is available in the script library here.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31711/

Nice article, Tim!

It's probably a limitation of the forum software.

I tend to open the active threads and then pop all the interesting ones into new tabs. Then I go back through them...

You can also download Log Rescue from Red Gate (I work for them). It's free because they're no longer selling it (hard to make money from this product), but it...

My guess is that the endpoint owner got "orphaned" similar to how a user can be orphaned when you restore on a new server without the login.

Glad it's working!

Any of the direct to disk products have burned many people here in the past. I have not heard of issues from Litespeed, Red Gate Backup, or the third party...

Very strange. Is it only the Litespeed jobs?

I wouldn't think that Litespeed has anything to do with it. The only thing that would make sense would be a time adjustment...

Bruce,

Congratulations and hope you've had a wonderful career!

Any great plans? Going to come back and give us some wonderful comments about how you're glad you don't have to deal with...

Thanks for the update. You might have some weird selectivity there with the data.

Good to know it's working.

You are welcome and thanks for the update.

If anything comes up, please post again here. Might help someone else.

The srvname should tell you which server. The table tells you if it's publishing or subscribing. Not sure about distributor.

that is very strange. Can you look at the plans for one good and one bad execution and see a difference?

Or post them?

Brian,

Very cool! I didn't realize you could do this in SS2K5. I think it' s probably an unintended "feature" from MS, but that is very handy. I'll have to...

If you have to, the logs can run on C, but I'd limit the max growth and perhaps even put a 1GB or so spaceholder out there for emergencies.