Hi all:

The following script was generated by a third party product to rename some columns for me:

EXECUTE sp_rename 'EXTRDETL.EXTRDETLID', 'pkEXTRDETL', 'COLUMN'
go

EXECUTE sp_rename 'EXTRDETL.EXTRMASTID', 'fkEXTRMAST', 'COLUMN'
go

EXECUTE sp_rename 'EXTRMAST.EXTRMASTID', 'pkEXTRMAST', 'COLUMN'
go

EXECUTE sp_rename 'EXTRSCRP.EXTRSCRPID', 'pkEXTRSCRP', 'COLUMN'
go

EXECUTE sp_rename 'EXTRSCRP.EXTRDETLID', 'fkEXTRDETL', 'COLUMN'
go

However, when this is executed (this also happens when executing from Query Analyzer), I get the following error:

Server: Msg 15248, Level 11, State 1, Procedure sp_rename, Line 163
Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.
Server: Msg 15248, Level 11, State 1, Procedure sp_rename, Line 163
Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.
Server: Msg 15248, Level 11, State 1, Procedure sp_rename, Line 163
Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.
Server: Msg 15248, Level 11, State 1, Procedure sp_rename, Line 163
Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.
Server: Msg 15248, Level 11, State 1, Procedure sp_rename, Line 163
Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.

I have reviewed BOL and I really don't see what the problem is with the script. I am logged in as SA and the appropriate database is selected when attempting this. 'COLUMN' is definitely an allowable option per BOL. Also, I've tried inserting a 'dbo.' in front of the table names and this does not resolve the apparent ambiguity either.

Anyone have any futher ideas?

Del