Hi,

I have checked and AutoShrink = False.

Here is some more info (in case)

SQL 2005

The Recovery mode = Full for some and Simple for others.

Backups occur every night

Transaction log backups every...

Hi,

Yes, the sequence of ALTER, stop the SQL Server and Agent services, move the files and start service is just what I had in mind.

As for the master - it's...

this is perfect - thanks!

Thanks! That's probably the best option. It's a bit of a mission to implement but it will do exactly what I need...

Thanks again.

thank you so much!!!

adding it as a table header works great.

Let me also add that the UPDATE statement is only suppose to update about 4,000 records based on the Join and the Conditions. So it's not that many records....

Thanks

If I go to Server objects - Linked Servers - LinkedServerName - Catalogs - System Catalogs - master - Systems Views, then the sys.sysaltfiles is listed. BUT when I right...

Hi Jamsin,

I have tried you suggestion, but no luck - I still receive the same error.

Hmmmm, this is strange

Thanks for all your replies, and it seems that the ALTER indexes were indeed the cause of all my problems.

I just have one final question:

How often would you suggest I...

I don't have mirroring or replication active but there is a maintenance task of reorganizing indexes, which is when the error occured. Any suggestions on this?

I will increase the...