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 |
|
kamii47
Constraint Violating Yak Guru
353 Posts |
 Posted - 2007-09-25 : 00:44:43
|
| How To rename a column name without stored procedure sp_renameI have 6 tables which contains data.I want's to send a script to simply rename the columnsI don't want's to use stored proceduresKamran ShahidSoftware Engineer(MCSD.Net)www.netprosys.com |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-25 : 01:38:12
|
| I don't get it, you want a script but you don't want to use sp_rename, why not?Kristen |
 |
|
|
kamii47
Constraint Violating Yak Guru
353 Posts |
Posted - 2007-09-25 : 02:19:12
|
| i might does n't have the rights to run stored procedure on the serverKamran ShahidSoftware Engineer(MCSD.Net)www.netprosys.com |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-25 : 02:53:32
|
| DDL changes should be done by just anyone!sp_rename requires sysadmin or db_owner, or alternatively db_ddladmin, which seems entirely appropriate to me.Kristen |
|
|
|
|
|
|
How To rename a column name without stored proc