just some thoughts...

is most of the database made up of one table?

what fill factor do you use when you rebuild, as the database is read only you can use 100%

do...

master will change when you make server level changes, so as you said when you change security, configurations or changes to other databases such as add or drop or move...

use the adventureworks database that comes with SQL

Lowell (3/30/2013)

---

Sp_help returns multiple data sets with different numbers of columnz. It also returns different results depending on the parameters and the object you are testint... a table returns diilfferent...

if this is giving you a serious issue frankly I would refer it to microsoft support, they are the experts on dump files.

As the OP has found and Gails blog shows, recovering from system database corruptions can be a complex and error prone process, especially for the model database. Microsoft and BOL...

run dbcc loginfo(yourdbname)

the row with a status column value of 2 is the last active vlf, you will not be able to shrink beyond that point.

edit forgot to spell check!

are you doing the insert in batches? after the first batch the table will no longer be empty so you will no longer get minimal logging.

then the log will have been filling up and growing, consuming your disk space. Set up regular log backups and existing space in the log file will be reused, preventing...

SQL_Surfer (3/25/2013)

---

Ah...I thought it truncates the log as well. My drive is running out of space so I am thinking taking log bacup will shrink the size of transaction log...

no , a log backup simply backs up the inactive part of the log file, it does not reduce the size of the file on disk.

Only a dbcc shrinkfile...

must be an error in copy and paste - you are missing a '.' - it should read master..sysdatabases

this code is compatible with all versions of sql from sql2000, you...

Jasons query returns the databases that ARE system databases so you would have to flip the logic.

I THINK SQL2005 includes the resource database in the query but SQL2008 and up...

duplicate post - relies to here please

all databases on the sql instance