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

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'
TimHudspithAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Seems like a Refresh issue, can you kindly refresh the table after altering the column name and try opening it in designer again.
0
 
TimHudspithAuthor Commented:
Well, I've tried it again and now it seems to be behaving as it should. I can't explain it.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes, it seems like a Refresh issue only.
0
 
TimHudspithAuthor Commented:
So is SQL Server known to be a bit temperamental in this respect? Something I should get used to?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
TimHudspithAuthor Commented:
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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
TimHudspithAuthor Commented:
How do I determine which SP I have?
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Try running this in your query window and it will tell the Service pack details.

select SERVERPROPERTY('productlevel')
0
 
TimHudspithAuthor Commented:
The result is SP1.
0
 
TimHudspithAuthor Commented:
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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
TimHudspithAuthor Commented:
That seems to have done it. Thanks.
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.

All Courses

From novice to tech pro — start learning today.