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 |
|
cardgunner
326 Posts |
 Posted - 2007-06-15 : 09:26:24
|
| I went to bol and used what they said however i get an error. My codeEXEC sp_rename 'allcaps.[FIELD1]','UCCID', 'FIELD1'my errorServer: Msg 15249, Level 11, State 1, Procedure sp_rename, Line 75Error: Explicit @itemtype 'FIELD1' is unrecognized (0).Am I doing something wrong other then Who ever imported this table didn't import in header names.Card Gunner |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-15 : 09:30:40
|
| EXEC sp_rename 'allcaps.[FIELD1]','UCCID', 'COLUMN'the last parameter is the object type.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
cardgunner
326 Posts |
Posted - 2007-06-15 : 09:37:52
|
| Thanks. I did that but not sure it worked. It said it did but as I looking at the columns it's still FIELD1.Do I need to close out of Analyer and get back in for iit to show?Card Gunner |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-15 : 09:44:06
|
| Try a right click and refresh on the objects or run select top 10 * from tbl==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
cardgunner
326 Posts |
Posted - 2007-06-15 : 10:15:58
|
| Yeah it's there.Thanks.Card Gunner |
|
|
|
|
|
|
Rename replace column name