BUG Cursor Jumps

I type in a query select * from tablename. I then want to edit it to select top 10 * from tablename.

When I type the work top and then the space It jumps to the end of my query moving the top keyword with it resulting in SELECT * FROM tablenameTOP

Sorry I am unable to reproduce it. Which editor do you use?

SQL Management Studio 9.00.2047.00

This still happens with version 1.0.46 of the product.

This still happens in 1.0.47 but I also tried differeing where I placed the top keyword ( after select or right before the * ) and I noticed that if I put the cursor after the word select and press space it moves the select keyword to the end of the query turning select * from tablename to * from tablename select

Are there plans to fix this??? It is very annoying and apparently it doesn't matter where in a query I am editting. if I press space it moves whatever was just inserted to the end. It is getting annoying to have to suspend SQLAssistant to edit my queries and turn them back on when I am done.

We are trying to reproduce that, but so far unsuccessful. Here is what really should happen.

Perhaps, you have

SELECT * FROM tablenam

You click after SELECT and press SPACE key you should get
SELECT <popup here> * FROM tablenam

and nothing should move.

Does it do the same thing if after placing cursor after SELECT keyword you press CTRL+SPACE instead of SPACE?

I understand what should happen.

I typed select * from tablename

I press ctrl+Space after the select and I get the appropriate pop up (GOOD!:))

I press just space and I get * FROM tablenameSELECT

I've got several versions of the Management Studio around here but not 9.00.2047.00

In all of them, what you are describing is not happening. What do I need to install to get 9.00.2047.00? Did it come with the SP1 or some other update?

By the way, this is issue is only specific to Management Studio. Right?

I only use SSMS so I can't attest to any other areas. You need to install SP1 on your machine and then you will have 2047

Well, I installed SP1. The about box in SSMS now says 9.00.2047 and no matter what I type or click in editor my cursor doesn't jump mysteriously to the end of the line moving current keyword along.

Please take a look at customizations you may have created in SSMS (Tools/Customize menu) that could be causing such anomaly, especially please check keyboard and editor settings.

I installed 1.0.49 and I removed red gates sql prompt to see if that was interferring. and the problem still happens.

I looked at the customizations and I didn't make any for keyboard and I don't see anything that would cause this issue. Are there known settings that interfer that I should change.

Any other ideas?

Developers suggested to turn off the keyword reformatting feature in SQL Assistant and wait and see until somebody else can reproduce this issue.

I did so and this does solve my problem. I really hope this can be reproduced at some point b/c I really like having the keyword formatted

Just an update this still happens in the newest version (1.0.55).

Just an update this still happens in the newest version (1.0.55).

I'm still not sure what to do about it. I'm unable to reproduce it and other people don't experience this mysterious jumping. Is there anyway for you to try other editors, perhaps try Windows Wordpad to see if the jumping is specific to SSMS or happens in any program?