Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-01-26 : 07:48:33
|
| What is wrong with this query please? Error is:Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.EXEC sp_rename @objname = '#tblMain.RENAME_data', @newname = 'data', @objtype = 'COLUMN' |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-26 : 07:52:59
|
| What database context are you running that in?btw, why would you need to rename a temp table column? Just give it the correct name when you create it--Gail ShawSQL Server MVP |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-01-26 : 07:55:47
|
| Solved by specifying the database nameThanks anyway |
|
|
|
|
|
|
rename field