Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

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)
0
brgdotnet
Asked:
brgdotnet
  • 3
  • 2
  • 2
  • +2
1 Solution
 
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
 
Pawan KumarDatabase 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now