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 |
|
Tigger
Yak Posting Veteran
85 Posts |
 Posted - 2003-02-24 : 16:06:00
|
What is the difference between-- reset identityDBCC CHECKIDENT ('t500_DR_Cred_Apnam_Circle_State', RESEED, 500)and-- reset identityDBCC CHECKIDENT ('t500_DR_Cred_Apnam_CorpPartner', RESEED, 500)(Other than the table name !!!)And the answer is:statement 2 would only work when I inserted a blank line after the comment !!  Only took me two hours to figure that one out ..... |
|
|
Tigger
Yak Posting Veteran
85 Posts |
Posted - 2003-02-24 : 16:14:23
|
| Have just discovered that if I retype statement 2 it works fine - aaarrggh !!What is going on here?I've had a similar problem before http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=23589There seems to be some bug in Query Analyzer where if I select a stored procedure from the object browser and choose edit it seems to inherit invisible characters or ignores bits of the code.Has anyone else had similar problems? Its driving me nuts. I've spent most of this morning trying to fathom out what was wrong withmy code when it was fine all along ... Even cutting and pasting into a new window does not fix the problem only retyping. The fun part is figuring out which line needs to be retyped |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-24 : 16:20:48
|
| Yes I have had this happen before. Luckily it's only been on small chunks of code. |
|
|
|
|
|
|
Spot the difference ...