Colin,

I mentioned truncating the tempDB log file as I assumed it would also be growing considerably alongside the data file.

Sorry Jeff, I did not check me previous reply:

How do you figure that the speed of the disk has anything at all to do with disk fragmentation?

--Jeff Moden

If file...

How do you figure that the speed of the disk has anything at all to do with disk fragmentation?

--Jeff Moden

The disks have to cope with concurrent IO requests from...

Try setting up a job to checkpoint tempDB and then truncate the tempDB Log. Schedule it to run every 5 minutes to start with and then adjust as necessary.

Are your backups local or remote?

If local do they use the same set of disks as the databases?

Have you checked the size of the log files and the...

Try the following link.

http://support.microsoft.com/kb/897284

Fragmentation will depend on the speed of the disk subsystem, availability of contiguous disk space and the workload. Whether a file grows automatically or if forced to grow manually,...

Most of the SP2 issues are resolved by applying cumulative hotfix

http://support.microsoft.com/kb/933097

followed by the additional hotfix

http://support.microsoft.com/kb/934459

to resolve CHECKDB problems.

Setting

@freq_subday_type=2,

will set the frequency to seconds.

Then setting

@freq_subday_interval=20,

will set the interval to be 20 seconds.

I just retested on a server with running 3 SQL Server 2005 instances and it ran successfully on all 3.

Do you have the backwards compatibility pack installed and...

The following code will script out all tables in a database. It uses sql-dmo so if you are using sql server 2005, ensure that the backwards compatibility pack is...

Isn't it necessary to supply the local parameter? As in:

sp_dropserver 'old_server_name'

GO

sp_addserver 'new_server_name', local

GO

Or is that only for a non-clustered server?

To be a little clearer, if you are changing the owner through SSMS the sequence is

Right-click on the database

Select properties

Select files

You will see the owner appear in a field...