I realize this is an old thread, but wanted to add.

The query is great, thanks Ian.

On one of my systems it was leaving out some open transactions so I made...

I see that in our environment for tables will a small rowcount. Apparently if it only takes a fraction of a page it shows as fragmented.

Look in the column TextData

I also had an instance where the database was one version 7.0 and the client tools were another 2000 that did the exact same thing.

If you append to your transaction log backup file you will also need to use the FILE= argument.

I have done this and programatically incremented the file number to restore multiple...

I am glad it worked for you.

Every DBA has a little anxiety now and then....

msdb contains the history of you job execution among other things. If you are interested in keeping this up to date then I would back up msdb as often as...

You might try sp_attach_db and see if you can reattach the database.

If this is all the records in the table you could truncate instead in seconds.

The time for a delete depends a great deal on your hardware and the other users...

Perform a full backup again and then the tran log backups should work. If the full backup has an error the tran log backups have no reference point and the...

I read the test requirements from the microsoft mcp site and read books online, Inside SQL, and worked with the product, then took the tests. It is work but it...

It may be a memory issue. Do a search for "locks option" in BOL.

execute select @@version. you may need to scroll to the right to see the part you are interested in.

First find out what table has the error:

select object_name(181575685)

You will need to run this for the correct database. You may be able to see which database was being checked...

Here is an article that talks about the error and the cause: http://www.standardio.org/article.aspx?id=215