I think this will take care of it. Thank you again Naomi.
>>Please tell me what is wrong with this. I was sure that I used this syntax before. What would be a better way to do this??
>>
>>
>> SET @SQLCmd = 'SELECT TOP 1 [name] FROM ' + QUOTENAME(@DBName) +
>> '.sys.all_objects where object_id = '+ CAST (@objectID AS VARCHAR(15))
>> SET @TblName = EXEC (@SQLCmd)
>>
>>
>>Your help is appreciated.
>
>See also FAQ #8130
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.