Did you run dbcc checktable against the table? does it have a PK?

Try this:

SELECT Sex, Distance, MIN(Time) AS Time

FROM RaceResults

GROUP BY Sex, Distance

ORDER BY Sex, Distance

I don't think you missed anything and I don't think you can select multiple servers in 2000 too. Becuase for different servers you may need to use different authentication methods

The process worked for me too.

However, you may still need to configure SQL suface area properly to make all your SPs work. Some features like xp_cmdshell is turned off by...

Yes, you don't need to create CompanyZ. You can restore from ComanyT backup to a database with any name and the restore process will create it. You cannot change the...

You need to write scripts to do this kind of thing.

e.g., add a int column to an existing table with default value 0:

IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE ID=OBJECT_ID('YourTableName')...

In the command of your original post,

RESTORE DATABASE sglue_md

FROM DISK = 'C:\sglue_md_20050804b.bak'

WITH REPLACE, MOVE 'DBName_Data' TO 'C:\MSSQL\DATA\sglue_md_Data.MDF',

MOVE 'sglue_md_Log' TO 'C:\MSSQL\DATA\sglue_md_Log.LDF'

As the error message suggested, did you run RESTORE FILELISTONLY?

What result you got? 

By the way, if you just want to change the name of a database, you donot need to detache and re-atche it with a differetn name. You can run sp_renamedb...

When you restore a database, by default in Enterprise manager shows the last back up you did. The UI has a drop down list "First backup to restore". From there you...

It's mostly because of the fragmentation of the database file.  The files are not in consecutive sectors in the hard drives. It causes the hard drives to take more time to move...

backup log just truncates the inactive logs, it does not shrink the log file. So the size of the file is not changed. But the used size should is reduced.

If...

The current activity folder is not refreshed automatically. The 2 open Trans just mean the process of 57 has two open transactions at the time when you open the folder....

log shipping sounds good. You need to use enterprise edtion of SQL server. Standard edtion does not support this.

you can call the extended procedure xp_cmdshell in your stored procedure:

DECLARE @sql nvarchar(1000)

SET @sql='DEL "'+@YourFile+'"'

exec master..xp_cmdshell @SQL

Make sure your app login has the privilege to run xp_cmdshell.