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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-11 : 06:12:24
|
| Shakeel writes "I renamed a view using sp_rename. The view was renamed successfully.But when I generate the script for this view, the create viewstatement in the script show only the old name instead of the new name.What is the resolution for this ?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-07-11 : 06:14:34
|
| You'll need to change the name in the script file after you script out the view. sp_rename will not alter the contents of the view definition, only its entry in sysobjects. |
 |
|
|
|
|
|
sp_rename bug