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 |
|
lfmn
Posting Yak Master
141 Posts |
 Posted - 2002-02-14 : 09:59:39
|
| I've run into a bug and I was wondering if anyone else has seen it. It has happened approx 12 -15 times in the past two months. I'm running SQL Server 7 with service pac 2.The problem first occured when I would run sp_helptext on a proc. I would copy the text from the lower query analyzer window and paste it into another analyzer window, rename it and try create the proc with a new name, but would get an error. After checking, I would find that either there was a carriage return in the middle of a word, or there was a letter missing from a word.Today, I encountered a new (but I think related) problem. I ran a stored procedure which I hadn't run for several months and received an error message. After tracking down the bug, I found that the letter i was missing from the word if in one of my if statements.If anyone has seen this problem, or knows of a fix, I would appreciate your help.cursors are like hammers - sometimes you have to use them, but watch your thumb! |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
lfmn
Posting Yak Master
141 Posts |
Posted - 2002-02-14 : 12:31:19
|
| that's the problem. thanks.I'm a microsoft developer and I try to support Microsoft, but to say that the work-around is to not use query analyzer ??????????????cursors are like hammers - sometimes you have to use them, but watch your thumb! |
 |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2002-02-14 : 13:00:22
|
| The page also says the problem is fixed with sp3======Doug G====== |
|
|
|
ToddV
Posting Yak Master
218 Posts |
Posted - 2002-02-14 : 16:56:56
|
| If you can not install sp3, perhaps you can fix things up by just getting a copy of sp_helptext from sp3. Maybe create an sp_helptext2. THe bug was probably in there (although it could have been with syscomments).Just an idea. |
|
|
|
|
|
|
|
|
SQL Server bug?