DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES

Thanks!

I did a DBREINDEX on all tables in my DB (individually) using this format:

use MYDB

DBCC DBREINDEX ('MYDB.Territories', '', 70)

After doing this, the logical fragmentation and extent fragmentation...

Can you accomplish the same thing with Backup and Restore?? I can find articles about restoring SQL Server 7.0 System Databases but not SQL Server 2000 and 2005 System...

Thank you so much! It's all starting to make sense now.. I guess I really didn't understand that it was creating a schema for...

Thanks for all the suggestions. I don't have any obsolete logins, just trying to figure out the best way to migrate the DB and...

Thank you

Guess I'm finding this out.. shoulda done it in chunks. my msdb database is 16mb

OK. The TLog backup files look fine in the backup directory. Files are named correctly, Tlog Backups ARE running every 2 hours and I AM getting an...

Thank you!!!

This procedure works GREAT - but it only give the most recent backup.. not a full History...

my output attached.

Does anyone know why I am only getting one days...

This looks like it will work for me... but I am getting Line 14: Incorrect syntax near 'XML'.

???

DECLARE @tableHTML NVARCHAR(50);

DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5), @days...

I agree ! works great and very helpfull !!! Two questions:

would like to schedule this to run and then write to a file or email results......

is there a '2005' version of this ?????

Had to enable CMD SHELL on 2005 and modify the SP to address the fact that 2000 backups with maintenance plans look like this: pubs_db_200801191728.BAK

where as 2005 backup files...

ok, i tried this again...

table exists on the subscriber DB but with zero rows..

table exists on the publisher with the correct primary key for replication...

I tried this..

Exec...