Solved

After renaming a column in SQL Server 2008, the name doesn't change in table design view

Posted on 2013-12-30
14
711 Views
Last Modified: 2013-12-30
Once I rename a column in a table by using sp_RENAME (as below), I can see that the name has changed when I view the table in 'edit all rows' mode, but it still has the old column name in design view. I refresh the table - and even the database - but the column still has the old name in design view. Only when I close and reopen SSMS has it updated.

sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'
0
Comment
Question by:TimHudspith
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 7
14 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 39745832
Seems like a Refresh issue, can you kindly refresh the table after altering the column name and try opening it in designer again.
0
 

Author Comment

by:TimHudspith
ID: 39745925
Well, I've tried it again and now it seems to be behaving as it should. I can't explain it.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 39745931
Yes, it seems like a Refresh issue only.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:TimHudspith
ID: 39745934
So is SQL Server known to be a bit temperamental in this respect? Something I should get used to?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 39745941
Actually it is not like that, SQL Server considers everything as a Session.
Object explorer is a session and your query window where you edited the table is a session.
Changes done in one session is not visible to the other session unless the other session refreshes it.
So, refreshing the object explorer will reflect the changes done for tables in other sessions.
0
 

Author Comment

by:TimHudspith
ID: 39745963
I've just added a column to a table and still have the same problem. I immediately went to the Object Explorer, selected the table, right-clicked, refreshed, then opened in Design view, but the new column was not added. By contrast it IS visible when I view the table via the 'edit all rows' option.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 39745983
I've tried it in my local with SQL Server 2008 SP3 installed and SQL Server 2008 R2 SP2 and it works fine without any issues. Can you kindly confirm whether you have the latest SP's installed for your instance and if not apply the latest SP's and try once..
0
 

Author Comment

by:TimHudspith
ID: 39746000
How do I determine which SP I have?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 39746021
Try running this in your query window and it will tell the Service pack details.

select SERVERPROPERTY('productlevel')
0
 

Author Comment

by:TimHudspith
ID: 39746031
The result is SP1.
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 39746050
If that is the case, can you try applying SP3 for SQL Server 2008 from the link below and check once.
http://www.microsoft.com/en-in/download/details.aspx?id=27594
0
 

Author Comment

by:TimHudspith
ID: 39746056
I have Windows 7. Which one do I download?

SQLServer2008SP3-KB2546951-IA64-ENU.exe
SQLServer2008SP3-KB2546951-x64-ENU.exe
SQLServer2008SP3-KB2546951-x86-ENU.exe
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 39746118
Hope you would be having a 64 bit machine, if that is the case then SQLServer2008SP3-KB2546951-x64-ENU.exe else SQLServer2008SP3-KB2546951-x86-ENU.exe
0
 

Author Comment

by:TimHudspith
ID: 39746196
That seems to have done it. Thanks.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
convert null in sql server 12 58
While in ##Table - Help 4 22
SQL Server maintenance plan 8 54
query output (script) from a stored procedure 4 39
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question