Viewing 3 posts - 1 through 3 (of 3 total)
I note point 5
[5] If Database is part of the qualified @objname,
then it must match the current database. The @newname parm can
never be qualified.
June 2, 2010 at 5:12 am
#1175206
ok thanks for your help
June 2, 2010 at 5:05 am
#1175201
Tried that with no luck .. same error message.
Can sp_rename used on tables out with the database you are using?
It works fine from with the current database
June 2, 2010 at 4:52 am
#1175194