sp_rename _BUG_ [英] sp_rename _BUG_
问题描述
这是直接出书sql 2000 for sp_rename
重命名存储过程，视图或触发器不会改变名称
的相应syscomments表中的对象名称。这可能会导致生成对象脚本的问题，因为旧名称
将从syscomments表插入到CREATE语句中。
为获得最佳结果，请勿重命名这些对象类型。相反，放弃并按
以新名称重新创建对象。
您知道任何变通方法吗？
This is straight out of books online sql 2000 for sp_rename
Renaming a stored procedure, view or trigger will not change the name
of the corresponding object name in the syscomments table. This may
result in problems generating a script for the object as the old name
will be inserted from the syscomments table into the CREATE statement.
For best results, do not rename these object types. Instead, drop and
re-create the object by its new name.
You know any workarounds?
推荐答案
" Larry Linson" < la *********** @ hotmail.comwrote in message
news：11 ******************* ***@b75g2000hsg.googlegr oups.com ...
"Larry Linson" <la***********@hotmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
这是直接在线书籍sql 2000 for sp_rename
重命名存储过程，视图或触发器不会更改syscomments表中相应对象名称的名称
。这可能会导致生成对象脚本的问题，因为旧名称
将从syscomments表插入到CREATE语句中。
为获得最佳结果，请勿重命名这些对象类型。相反，放弃并按照新名称重新创建对象。
您知道任何变通方法吗？
This is straight out of books online sql 2000 for sp_rename
Renaming a stored procedure, view or trigger will not change the name
of the corresponding object name in the syscomments table. This may
result in problems generating a script for the object as the old name
will be inserted from the syscomments table into the CREATE statement.
For best results, do not rename these object types. Instead, drop and
re-create the object by its new name.
You know any workarounds?
相反，删除并以新名称重新创建对象的一部分你理解了吗？b
$ b ;-)
Michael
What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)
Michael
相反，删除并以新名称重新创建对象的部分内容做了
What part of "Instead, drop and re-create the object by its new name" did
你有理解吗？ ;-)
you have trouble understanding? ;-)
迈克尔，这不是你回应的Access MVP Larry Linson，
而是别名Aaron Kempf用于曳。请忽略
他的帖子并且不回复他（正如俗话所说的那样请不要喂b / b巨魔）。
谢谢，
Seth Rowe
3月27日，上午12:37，Michael C < nos ... @nospam.comwrote：
Michael, this is not the Access MVP Larry Linson you are responing to,
but instead an alias Aaron Kempf uses for trolling. Please disregard
his posts and do not respond to him (as the saying goes "do not feed
the trolls").
Thanks,
Seth Rowe
On Mar 27, 12:37 am, "Michael C" <nos...@nospam.comwrote:
" Larry Linson" < larrylinso ... @ hotmail.com写信息
新闻：11 ********************** @ b75g2000hsg.googlegr oups.com ...
"Larry Linson" <larrylinso...@hotmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
这是直接出书sq 2000 for sp_rename
This is straight out of books online sql 2000 for sp_rename
重命名存储过程，视图或触发器不会更改syscomments表中相应对象名称的名称
。这可能会导致生成对象脚本的问题，因为旧名称
将从syscomments表插入到CREATE语句中。
为获得最佳结果，请勿重命名这些对象类型。相反，drop和
按其新名称重新创建对象。
Renaming a stored procedure, view or trigger will not change the name
of the corresponding object name in the syscomments table. This may
result in problems generating a script for the object as the old name
will be inserted from the syscomments table into the CREATE statement.
For best results, do not rename these object types. Instead, drop and
re-create the object by its new name.
您知道任何变通方法吗？
You know any workarounds?
相反，删除并以新名称重新创建对象的一部分"你理解了吗？b
$ b ;-)
Michael
What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)
Michael
Michael
STFU并修复你该死的该死的虫子
这是一个BUG没有解决方法
修复BUG，MICROSOFT
3月26日9:37 pm，Michael C < nos ... @nospam.comwrote：
Michael
STFU and fix the damn bug you retard
this is a BUG there is no workaround
FIX THE BUG, MICROSOFT
On Mar 26, 9:37 pm, "Michael C" <nos...@nospam.comwrote:
" Larry Linson" < larrylinso ... @ hotmail.com写信息
新闻：11 ********************** @ b75g2000hsg.googlegr oups.com ...
"Larry Linson" <larrylinso...@hotmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.com...
这是直接出书sq 2000 for sp_rename
This is straight out of books online sql 2000 for sp_rename
重命名存储过程，视图或触发器不会更改syscomments表中相应对象名称的名称
。这可能会导致生成对象脚本的问题，因为旧名称
将从syscomments表插入到CREATE语句中。
为获得最佳结果，请勿重命名这些对象类型。相反，drop和
按其新名称重新创建对象。
Renaming a stored procedure, view or trigger will not change the name
of the corresponding object name in the syscomments table. This may
result in problems generating a script for the object as the old name
will be inserted from the syscomments table into the CREATE statement.
For best results, do not rename these object types. Instead, drop and
re-create the object by its new name.
您知道任何变通方法吗？
You know any workarounds?
相反，删除并以新名称重新创建对象的一部分"你理解了吗？b
$ b ;-)
Michael
What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)
Michael
这篇关于sp_rename _BUG_的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
