Author |
Message |
neverden
Joined: 02 Dec 2008 Posts: 58
|
|
|
|
yes, it was set to ADO.NET
|
|
Mon May 24, 2010 9:38 am |
|
 |
neverden
Joined: 02 Dec 2008 Posts: 58
|
|
|
|
FYI: I closed SSMS and reopened it and the flicker came back. I had to enable and disable the spell check again. It seems like the setting isn't sticking?
|
|
Mon May 24, 2010 2:50 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
The settings are stored in the config files and some in the registry. They are not sticking when Windows is undoing them after you logoff. To make these change permanent, please start SSMS in Run As Administrator mode, make the required changes in the settings and then restart SSMS normally or just turn off UAC.
|
|
Mon May 24, 2010 7:04 pm |
|
 |
neverden
Joined: 02 Dec 2008 Posts: 58
|
|
|
|
I don't think you undserstand. It looks like its disabled but stil flickering. I have to enable and then disable to get it to stop. I do not logoff. I just restart ssms and it come back.
|
|
Tue May 25, 2010 6:19 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
We are likely talking about different things. I didn't mean spell checker. Spell checker is dormant until you manually activate it. I meant SQL syntax checker. To disable that feature, wait for the syntax bar to appear on the right of the editor screen, the right-click it and select Auto check -> Off menu. This should help.
The flickering is most likely a result of your remote system slow screen repainting. The syntax checker is drawing wavy red lines and other things on top of the SSMS normal screen and this leads to additional screen repainting after each scroll, text change, etc…, which is normally not an issue and not visible when working with a local editor.
|
|
Tue May 25, 2010 8:45 am |
|
 |
neverden
Joined: 02 Dec 2008 Posts: 58
|
|
|
|
right, but why does it stop if I enable and then disable spell checked and why doesn't it happen in 4.8?
|
|
Tue May 25, 2010 11:33 am |
|
 |
birgerii
Joined: 21 Feb 2007 Posts: 29
|
|
|
Wed May 26, 2010 4:43 am |
|
 |
neverden
Joined: 02 Dec 2008 Posts: 58
|
|
|
|
thank you birgerii. Does it come back for you after you restart SSMS?
|
|
Wed May 26, 2010 5:51 am |
|
 |
birgerii
Joined: 21 Feb 2007 Posts: 29
|
|
|
|
I've tried to disable as much as possible and restarted as well, but it still flickers. Even when I just step through the code using the arrows.
|
|
Wed Jun 02, 2010 1:59 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Just in case, SQL Assistant is setup and running as a SSMS add-on? not attaching to SSMS from the system tray application?
|
|
Wed Jun 02, 2010 2:09 am |
|
 |
birgerii
Joined: 21 Feb 2007 Posts: 29
|
|
|
|
I don't know how to run it as an add-on. And I run mostly SQL Query Analyzer, and it flickers a lot on every key release.
|
|
Wed Jun 02, 2010 2:33 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
You stated in the initial post you are having an issue with SSMS, that's why we focused on SSMS
Is that a remote desktop connection, Citrix, remote terminal session, or something similar? If yes, is that conenction slow?
|
|
Wed Jun 02, 2010 2:37 am |
|
 |
birgerii
Joined: 21 Feb 2007 Posts: 29
|
|
|
|
In my initial post (http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=23096&start=0&postdays=0&postorder=asc&highlight=), I told you I was using Query Analyzer, it is "neverden" that has the experience with SSMS.
I notice the flickering even if I run SQL2000 on my laptop:
Operativsystemets namn Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 3 build 2600
Operativsystemets tillverkare Microsoft Corporation
Datornamn DTS-BOR-PC62
Datortillverkare Hewlett-Packard
Datormodell HP Compaq 6710b (GB892ET#AK8)
Datortyp X86-baserad dator
Processor x86 Family 6 Model 15 Stepping 11 GenuineIntel ~2194 Mhz
BIOS-version och -datum Hewlett-Packard 68DDU Ver. F.0B, 2007-08-02
SMBIOS-version 2.4
Windows-katalog C:\WINDOWS
Systemkatalog C:\WINDOWS\system32
Startenhet \Device\HarddiskVolume1
Nationella inställningar Sverige
HAL (Hardware Abstraction Layer) Version = "5.1.2600.5512 (xpsp.080413-2111)"
Tidszon Västeuropa, sommartid
Sammanlagt fysiskt minne 2 048,00 MB
Tillgängligt fysiskt minne 589,80 MB
Sammanlagt virtuellt minne 2,00 GB
Tillgängligt virtuellt minne 1,96 GB
Växlingsfilsutrymme 3,33 GB
Växlingsfil C:\pagefile.sys
|
|
Wed Jun 02, 2010 2:54 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Is there any text highlighted when you see the heavy flickering? Any SQL Assistant windows/panes/bookmarks open? If yes, on which side of the SQL Query Analyzer window?
Does the amount of flickering depend on the size of the script in the editor? Does it depend on the syntax checker enabled/disabled state?
|
|
Wed Jun 02, 2010 3:08 am |
|
 |
birgerii
Joined: 21 Feb 2007 Posts: 29
|
|
|
|
No text is highlighted
No SQL Assistant windows/panes/bookmarks open
I can't say that I notice any difference between 50 rows and 1000 rows
No significant difference while stepping through the code when syntax checker enabled/disabled. If enabled on three seconds, a quick flickering can be noticed after three seconds of none-movement.
|
|
Wed Jun 02, 2010 4:25 am |
|
 |
|