sp_rename _BUG_

**Michael C** · Mar 27 '07, 04:45 AM

Re: sp_rename _BUG_

"Larry Linson" <larrylinsonjr@ hotmail.comwrot e in message
news:1174947526 .734620.251440@ b75g2000hsg.goo glegroups.com.. .

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?

What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)

Michael

**rowe_newsgroups** · Mar 27 '07, 11:15 AM

Re: sp_rename _BUG_

What part of "Instead, drop and re-create the object by its new name" did

you have trouble understanding? ;-)

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.comwrot e in message
>
news:1174947526 .734620.251440@ b75g2000hsg.goo glegroups.com.. .
>

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?

>
What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)
>
Michael

**Larry Linson** · Apr 3 '07, 05:25 PM

Re: sp_rename _BUG_

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.comwrot e in message
>
news:1174947526 .734620.251440@ b75g2000hsg.goo glegroups.com.. .
>

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?

>
What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)
>
Michael

**Larry Linson** · Apr 3 '07, 05:25 PM

Re: sp_rename _BUG_

Seth;

I am RIGHT and I am standing up QUESTIONING A BUG THAT MICROSOFT HAS
SUBJECTED US ALL TO FOR A DECADE

STFU AND FIX IT MICROSOFT THERE IS NO WORKAROUND

On Mar 27, 4:10 am, "rowe_newsgroup s" <rowe_em...@yah oo.comwrote:

What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)

>
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.comwrot e in message

>

news:1174947526 .734620.251440@ b75g2000hsg.goo glegroups.com.. .

>

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?

>

What part of "Instead, drop and re-create the object by its new name" did
you have trouble understanding? ;-)

>

Michael- Hide quoted text -

>
- Show quoted text -

**Rory Becker** · Apr 3 '07, 06:15 PM

Re: sp_rename _BUG_

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").

Whilst your post was not intended for me directly.

I'd like to thank you for this info anyway. :)

--
Rory

hmmmm...."Do not feed the trolls"....inte resting....
Is there a virtual way we can point and laugh at them? :P

**RobinS** · Apr 4 '07, 05:45 AM

Re: sp_rename _BUG_

"Rory Becker" <RoryBecker@new sgroup.nospamwr ote in message
news:b0ac48a07f 5a8c9443a85214b f0@msnews.micro soft.com...

>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").

>
Whilst your post was not intended for me directly.
I'd like to thank you for this info anyway. :)
>
>
--
Rory
>
hmmmm...."Do not feed the trolls"....inte resting.... Is there a virtual
way we can point and laugh at them? :P
>
>

Maybe whoever created this had TrollBoy in mind: http://piv.pivpiv.dk/

Robin S.
p.s.Someone posted that a while back, and it really cracked me up.

**PFC Sadr** · Apr 4 '07, 01:05 PM

Re: sp_rename _BUG_

I'm contributing to this thread; STFU bitch

On Apr 3, 10:41 pm, "RobinS" <Rob...@NoSpam. yah.nonewrote:

"Rory Becker" <RoryBec...@new sgroup.nospamwr ote in message
>
news:b0ac48a07f 5a8c9443a85214b f0@msnews.micro soft.com...
>
>
>
>
>

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").

>

Whilst your post was not intended for me directly.
I'd like to thank you for this info anyway. :)

>

--
Rory

>

hmmmm...."Do not feed the trolls"....inte resting.... Is there a virtual
way we can point and laugh at them? :P

>
Maybe whoever created this had TrollBoy in mind:http://piv.pivpiv.dk/
>
Robin S.
p.s.Someone posted that a while back, and it really cracked me up.- Hide quoted text -
>
- Show quoted text -

**Rory Becker** · Apr 4 '07, 01:25 PM

Re: sp_rename _BUG_

Some people will say I'm wasting my time with what I'm about to say.

I will however try...

I'm contributing to this thread

While this may or may not be true in any given case....

>STFU bitch

.... will get you named a Troll and rightly so.

If you feel you would like to contribute, please try to address people and
entities with at least a small degree of respect.

I appriciate that MS are not perfect (far from it in many cases)

But I doubt they will listen to any genuine concerns that you have while
your attitute/language remains at this level.

I think it fair that everyone is given a second chance.

If you start to show a little respect, then I'm sure others will also do
the same.

I do not mean to sound condacending, so If you feel I have insulted you then
I appologise.

However you will, I think, get very few olive branches before someone burns
the tree down

--
Rory

**rowe_newsgroups** · Apr 4 '07, 04:45 PM

Re: sp_rename _BUG_

On Apr 4, 9:16 am, Rory Becker <RoryBec...@new sgroup.nospamwr ote:

Some people will say I'm wasting my time with what I'm about to say.
>
I will however try...
>

I'm contributing to this thread

>
While this may or may not be true in any given case....
>

STFU bitch

>
... will get you named a Troll and rightly so.
>
If you feel you would like to contribute, please try to address people and
entities with at least a small degree of respect.
>
I appriciate that MS are not perfect (far from it in many cases)
>
But I doubt they will listen to any genuine concerns that you have while
your attitute/language remains at this level.
>
I think it fair that everyone is given a second chance.
>
If you start to show a little respect, then I'm sure others will also do
the same.
>
I do not mean to sound condacending, so If you feel I have insulted you then
I appologise.
>
However you will, I think, get very few olive branches before someone burns
the tree down
>
--
Rory

Rory, while I appreciate your attempt at pacification, I have to ask
that you don't respond to Aaron at all. Many have stated the same
arguments (and more) you made to Aaron and they have not and will not
make any difference. He is not here to get Microsoft to change, or to
help others, he is only here to troll. Any response of any kind to him
or about him (including this one) will only encourage him to troll
more.

Thanks,

Seth Rowe

**Larry Linson** · Apr 10 '07, 11:15 PM

Re: sp_rename _BUG_

why don't you stfu and start petitioning microsoft to FIX BUGS

a workaround that is a pain in the ass-- for something that I do 100
times a day?
GET REAL MICROSOFT

On Apr 4, 6:16 am, Rory Becker <RoryBec...@new sgroup.nospamwr ote:

Some people will say I'm wasting my time with what I'm about to say.
>
I will however try...
>

I'm contributing to this thread

>
While this may or may not be true in any given case....
>

STFU bitch

>
... will get you named a Troll and rightly so.
>
If you feel you would like to contribute, please try to address people and
entities with at least a small degree of respect.
>
I appriciate that MS are not perfect (far from it in many cases)
>
But I doubt they will listen to any genuine concerns that you have while
your attitute/language remains at this level.
>
I think it fair that everyone is given a second chance.
>
If you start to show a little respect, then I'm sure others will also do
the same.
>
I do not mean to sound condacending, so If you feel I have insulted you then
I appologise.
>
However you will, I think, get very few olive branches before someone burns
the tree down
>
--
Rory

**Larry Linson** · Apr 10 '07, 11:15 PM

Re: sp_rename _BUG_

I AM NOT HERE TO GET MS TO CHANGE?

WHAT ARE YOU TALKING ABOUT KID

JUST BECAUSE YOU DO NOT HAVE THE BALLS TO USE UPPER CASE LETTERS?
DOES THAT MAKE YOU RIGHT?

SERIOUS KIDS GROW UP, STFU MICROSOFT AND FIX THIS BUG NOW

On Apr 4, 9:43 am, "rowe_newsgroup s" <rowe_em...@yah oo.comwrote:

On Apr 4, 9:16 am, Rory Becker <RoryBec...@new sgroup.nospamwr ote:
>
>
>
>
>

Some people will say I'm wasting my time with what I'm about to say.

>

I will however try...

>

I'm contributing to this thread

>

While this may or may not be true in any given case....

>

>STFU bitch

>

... will get you named a Troll and rightly so.

>

If you feel you would like to contribute, please try to address people and
entities with at least a small degree of respect.

>

I appriciate that MS are not perfect (far from it in many cases)

>

But I doubt they will listen to any genuine concerns that you have while
your attitute/language remains at this level.

>

I think it fair that everyone is given a second chance.

>

If you start to show a little respect, then I'm sure others will also do
the same.

>

I do not mean to sound condacending, so If you feel I have insulted you then
I appologise.

>

However you will, I think, get very few olive branches before someone burns
the tree down

>

--
Rory

>
Rory, while I appreciate your attempt at pacification, I have to ask
that you don't respond to Aaron at all. Many have stated the same
arguments (and more) you made to Aaron and they have not and will not
make any difference. He is not here to get Microsoft to change, or to
help others, he is only here to troll. Any response of any kind to him
or about him (including this one) will only encourage him to troll
more.
>
Thanks,
>
Seth Rowe- Hide quoted text -
>
- Show quoted text -

sp_rename _BUG_

sp_rename _BUG_

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment