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? 11 1328
"Larry Linson" <la***********@hotmail.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.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
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.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.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
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.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.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
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_newsgroups" <rowe_em...@yahoo.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.comwrote in message
news:11**********************@b75g2000hsg.googlegr oups.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 -
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"....interesting....
Is there a virtual way we can point and laugh at them? :P
"Rory Becker" <Ro********@newsgroup.nospamwrote in message
news:b0*************************@msnews.microsoft. 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"....interesting.... 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.
I'm contributing to this thread; STFU bitch
On Apr 3, 10:41 pm, "RobinS" <Rob...@NoSpam.yah.nonewrote:
"Rory Becker" <RoryBec...@newsgroup.nospamwrote in message
news:b0*************************@msnews.microsoft. 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"....interesting.... 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 -
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
On Apr 4, 9:16 am, Rory Becker <RoryBec...@newsgroup.nospamwrote:
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
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...@newsgroup.nospamwrote:
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
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_newsgroups" <rowe_em...@yahoo.comwrote:
On Apr 4, 9:16 am, Rory Becker <RoryBec...@newsgroup.nospamwrote:
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 -
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Ted Theodoropoulos |
last post by:
i have a dts package that is going to run at night and pull data from
2 tables in an Oracle db and load it to 2 staging tables that my
package creates in sql server 2000. i then execute a few...
|
by: Barry Young |
last post by:
SQL Server 7.0
I have a stored procedure that builds some tables. To minimize down time
(it is the backend for a website), I build the tables into temp (not #temp)
tables, drop and rename the...
|
by: mokles |
last post by:
Hi All,
I am trying to change column name on an existing table. I am using SQL
Server 7.
As the table is quite big, it is taking quite long time to do it.
By the way I could change the column...
|
by: Christopher Benson-Manica |
last post by:
"I came across some code that declared a structure like this:
struct name {
int namelen;
char namestr;
};
and then did some tricky allocation to make the namestr array act like it had...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |