Bingo Chris ... time to "recover from your most recent database backup" ...

I do not believe that this informaiton is documented for general public use. The only resolution may be to recover from your most recent database backup. Another possibility is that...

Try removing the square brackets [] from the server/instance, these have a different meaning/usage in a DOS command shell than what SQL Server uses them for.

Tahir, for v7.0 your are correct.

I'd attribute it to another 'un-documented feature' (bug) left over from the old Sybase code base ...

You are correct Mike ... I made an 'assumption' that everyone does the proper maintenance ... including that !

Here's the login transfer script the many others use:

http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q246133

To check things out properly you'll need to run the following in QA:

    exec your_database..sp_spaceused

    go

    dbcc sqlperf(loginfo)

    go

This will give use space for both the database and the transaction...

yup ... scan BOL for the following: table and index architecture ...

Most of the potential issues raised (management, locked out accounts, security, etc) are really no-brainers when one sits down and plans a bit. Every site I've been at for the last...

This will work, but there is an unstated underlying issue here. Why are your transaction logs set to 'unlimited' growth ? Are they not managed ? Is the application that...

I would probably set up a SQL Task to import the data. This way when it is executed you'd have a history. Also the 'outsourcing' company would just have to...

RAID 5 is optimized for read. Also, RAID5 or 1+0 0n a SAN does not make a huge difference unless your SAN is overworked and has insufficient cache.

Intel over AMD...

none ... figured it out in v4.21a ... it's been the same ever since !

DOn't forget to stop/restart SQL Server ... @@servername is set on starting the server.