Ok..this is a weird one.
When I open up SQL Server Management Studio Express my menubar has multiple
instances of the File, Edit, View...menu options... and every toolbar
(Standard, Query Designer, Database Diagram, etc..) all have multiple options
as well.
I've gone in an modified those items as well and I get it to a point where
it looks ok, then when I shut it down and re-open it, all my changes are gone
and it's back to the way it was.
Can anyone help me on this one? Is this the right place to post this
question?
Thanks in advance,
John Scott.
SQL Server 2005 stores it's configuration information in following location:
My Documents\SQL Server Management
Studio\Settings\CurrentSettings-2007-06-06.vssettings
Check to make sure there is no writing problems to that.
The path information for the config file is located at
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\90\Tools\Shell\Profile\
Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John Scott" wrote:
> Ok..this is a weird one.
> When I open up SQL Server Management Studio Express my menubar has multiple
> instances of the File, Edit, View...menu options... and every toolbar
> (Standard, Query Designer, Database Diagram, etc..) all have multiple options
> as well.
> I've gone in an modified those items as well and I get it to a point where
> it looks ok, then when I shut it down and re-open it, all my changes are gone
> and it's back to the way it was.
> Can anyone help me on this one? Is this the right place to post this
> question?
>
> --
> Thanks in advance,
> John Scott.
|||Thank for the reply Mohit,
I checked two things...there are some goofy entries in the vssettings file
in my My Documents...file.
I made changes to it, but there is no change when I open up SQL Express...
I also checked and I don't have the
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\90\Tools\Shell\Profile\ key I have all the way up to the Shell..I
have no Profile in there.
Other suggestions?
Thanks,
John Scott.
"Mohit K. Gupta" wrote:
[vbcol=seagreen]
> SQL Server 2005 stores it's configuration information in following location:
> My Documents\SQL Server Management
> Studio\Settings\CurrentSettings-2007-06-06.vssettings
> Check to make sure there is no writing problems to that.
> The path information for the config file is located at
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\90\Tools\Shell\Profile\
> Thanks!
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "John Scott" wrote:
|||Sorry for late reply.
Sorry the proper path in registry is
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\90\Tools\ShellSEM\Profile\.
I can't get the issue to replicate. Here are two options ...
- Delete the CurrentSettings-DATE.vsssettings file.
This will force SSMSEE to reinitialize the settings. Do a search on your
computer for vsssettings delete anything with CurrentSettings in it.
OR
- Try Reinstalling the SSMSEE.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
|||Ok...I did a few things.
1. I deleted my CurrentSettings file in ssmses settings folder...when I
opened up ssmses it poped up a message saying it coudn't find my settings
folder and that it would use the most recent settings for this session
2. I checked that registry path...and i did find it, didn't find anything
out of the ordinary...it had 13 values inside that key
AutoSaveFile
AutoSaveFILETIMEHigh
AutoSaveFILETimeLow
BuildNum
DefaultSettinsDirectory
LastResetSettingsFile
SettingsCachesFILEIMEHigh
SettingsCachesFILEIMELow
Sku
TeamSettingsFile
TeamSettingsFILETIMEHigh
TeamSettingsFILETIMELow
TraackTeamSettings
for the LastResetSettingsFile the value was
'%vsspv_vs_install_directory%\Profiles\ssmsee.vsse ttings'
I checked out this file and there is a node called Caegory
name="Environment_WindowLayout"
inside it, there is another node call "PropertyVale name="WindowLayout">
then after that there is a whole bunch of garbled text (looks like viewstate
data)
then the PropertyValue node closes...
I don't know if that is normal or not...
Any other suggestions?
Thanks,
John Scott.
"Mohit K. Gupta" wrote:
> Sorry for late reply.
> Sorry the proper path in registry is
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\90\Tools\ShellSEM\Profile\.
> I can't get the issue to replicate. Here are two options ...
> - Delete the CurrentSettings-DATE.vsssettings file.
> This will force SSMSEE to reinitialize the settings. Do a search on your
> computer for vsssettings delete anything with CurrentSettings in it.
> OR
> - Try Reinstalling the SSMSEE.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
|||Delete all settings files. I would just try reinstalling though.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John Scott" wrote:
[vbcol=seagreen]
> Ok...I did a few things.
> 1. I deleted my CurrentSettings file in ssmses settings folder...when I
> opened up ssmses it poped up a message saying it coudn't find my settings
> folder and that it would use the most recent settings for this session
> 2. I checked that registry path...and i did find it, didn't find anything
> out of the ordinary...it had 13 values inside that key
> AutoSaveFile
> AutoSaveFILETIMEHigh
> AutoSaveFILETimeLow
> BuildNum
> DefaultSettinsDirectory
> LastResetSettingsFile
> SettingsCachesFILEIMEHigh
> SettingsCachesFILEIMELow
> Sku
> TeamSettingsFile
> TeamSettingsFILETIMEHigh
> TeamSettingsFILETIMELow
> TraackTeamSettings
>
> for the LastResetSettingsFile the value was
> '%vsspv_vs_install_directory%\Profiles\ssmsee.vsse ttings'
> I checked out this file and there is a node called Caegory
> name="Environment_WindowLayout"
> inside it, there is another node call "PropertyVale name="WindowLayout">
> then after that there is a whole bunch of garbled text (looks like viewstate
> data)
> then the PropertyValue node closes...
> I don't know if that is normal or not...
> Any other suggestions?
>
> --
> Thanks,
> John Scott.
>
> "Mohit K. Gupta" wrote:
No comments:
Post a Comment