Not able to create a new table in sql server management studio. Error :The system cannot find the file specified.

I am using SQL Server 2008. I am trying to create a new SQL table in sql server management studio. If I right click on the "Tables"
in order to creat a new table, I get an error message, as shown below. Any idea what is causing this issue? I have created tables
hundreds of times this way, however today I am getting the error message?

Right click "New Table..."
The error message reads :
The system cannot find the file specified.
(SQLEditors)
LVL 2
brgdotnetcontractorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
Try..

Go to Registry

--

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

Add a new Expandable String Value called 'AppData' and give it the value - %userprofile%\Application Data.

--

Open in new window

0
 
chaauCommented:
I think it is the IDE problem. A recent installation/uninstallation may have caused it. A simple restart of the SSMS or the PC may help solve it
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Was it working on this environment before?
What is the version of SQL Server to which you are connected to in SSMS?
What changes were recently made to this environment?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Please don't change nothing in the Registry if you don't know what and why are you doing it.
I second Chaau on the IDE problem. What version of SSMS are you using? Did you apply any MSSQL patch recently?
Btw, I never in my life created a table using SSMS GUI. I prefer to use the SQL query window and run the proper CREATE TABLE command and then I can save it as a script file (.sql) for later use if necessary. You should start to work more and more with SQL commands rather than the GUI.
0
 
brgdotnetcontractorAuthor Commented:
I am still trouble shooting this, and will try to resolve it soon, thanks everyone.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
brgdotnet, there are any news about this issue?
0
 
brgdotnetcontractorAuthor Commented:
The update to the Registry as Pawan suggested worked perfectly.
0
 
Pawan KumarDatabase ExpertCommented:
Great ! Thank you brgdotnet !!

Regards,
Pawan
0
 
Pawan KumarDatabase ExpertCommented:
Hi brgdotnet,
Could you please select the answer that helped and submit. :)

Thank you in advance. !!

Regards,
Pawan
0
All Courses

From novice to tech pro — start learning today.