If this is after your log backups, then it should be a minimal amount of log data lost. It does mess up your backup chain, so you do need a...

Only Service Packs are cumulative.

You can use a trigger or schedule a job to do this periodically.

I think it pulls some rows and then starts to return them. As you access more, it pulls more. Curious, is there an ORDER BY clause in the select?

The other...

I might also try rebuilding the clustered index and seeing if you can rebuild the structure of the table.

You cannot have multiple primary keys on a table. You can have multiple indexes, even unique indexes, but only one primary key.

They could be compound keys.

Frank,

Excellent points and I may have to pick up an old Zaurus and see if I can get RDP running under Linux

Thanks for the kind words from all three of us.

Steve

Good points. However, we did lots of work with 486-66's and previous. There were many tasks that we could complete. It's as we evolved that we have built so much...

Service packs are not listed anywhere. You go off the build version and compare it to http://vyaskn.tripod.com/sqlsps.htm

Interesting solutions and thanks. I said 1 myself, but both are interesting solutions.

I also think that the requirements, asking to read the table once, are misleading. I don't think that...

Jan,

There is no easy way to do this. Something needs to connect to both servers and compare the data. You could send your master db to the customers and run...

Also you will need to configure outlook using the account that runs SQL Server.

Really you'd need to track your database size on a daily or weekly period and then use that. Error logs work as well, but if you are having regular growths,...

Post moved.

Prakesh, what are you trying to do? You can "close" the database with autoclose and resources will be released, but if someone accesses the database, it will reopen. This...