Thank you - trailing spaces will have to be my option then.

I received this request from a client of ours and he (not being too IT literate) specifically asked for...

hmmm I have been getting that response from most people - that it can't be done.

I am definitely talking about fixed-width: as in all the columns must be of equal...

Thanks for all your replies - appreciate it!!

I have used the following statement:

exec sp_msforeachdb 'select ''?'', filename from ?..sysfiles'

it lists all my DBs and the individual mdf and ldf file per DB, and the extra mdf and...

free_mascot: how would I check that?

I have used that SP and it has confirmed the 2 locations:

D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DBName.mdf

D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DBName_Log.ldf

This will seem like a stupid question, but is it possible that those other MDF...

Ok there was a Shrink DB option in the Maintenance plan that executed every night at 12:00

I have disabled that.

I will keep an eye on it - see if this...

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