CODEWITHSUNDEEP
sql-server
Arron
Arron

Reputation: 31

Unable to Edit top 200 rows in SQL Server Management Studio 2014(X64)

I am unable to edit top 200 rows in SQL Server. Everytime I click edit top 200 rows I receive this message and sql server restarts. enter image description here

I have tried to reinstall SQL Server management and also tried to

– Copy and replace the DLL “dsref80.dll” in below path from a machine where SSMS is working fine in to the machine where the problem exists. C:\Program Files (x86)\Common Files\microsoft shared\Visual Database Tools\dsref80.dll – Replace all the files in below folder using the files from another server where SSMS is working fine. C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8\ – Close and Open SSMS.

None of these solutions seem to work

Upvotes: 2

Views: 13345

Answers (2)

Kester
Kester

Reputation: 21

I got the same issue and found the reason: I was connecting to a SQL Server 2014 database using SQL Server Management Studio 2012.

Installing and using SQL Server Management Studio 2014 rectified the problem.

It appears that they are not compatible. Though it should be noted that I didn't have any service packs installed for either version.

Upvotes: 2

10100111001
10100111001

Reputation: 1832

Did you recently install multiple .NET Framework applications and MS software? If so, you might need to reset your network adapter.

Try running the following command in CMD (Run as Administrator):

netsh winsock reset

--- Update ---

Are you updated to the latest SQL Server 2014 SP?

Check your version by using this SQL statement:

USE master
SELECT @@version

The latest version is SQL Server 2014 SP2 (12.0.5000.0 – July 2016).

Upvotes: 1

Related Questions