I am ripping my hair out here trying to do something on a SQL Server 2000 box using TSQL that is a breeze in SQL 2005 but I can't make it work.

I am trying to do this ... VERSION 1

SET @DatabasePath = N'D:\DATA\Maint enance\'
SET @LOGBackupPath = N'E:\LOGS\Maint enance\'
SET @Retention = 1

/* modify NOTHING below this line !!!!! */

SET @TableName = @DatabasePath + N'Maintenance.m df'...