Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server T-SQL
I renamed a database using the ssmse2k8 interface a long time ago. I was reflecting the addition of a new drive on the system by appending a "W" to the existing name.
 
Today, a year and a half later, I ran:
 
SELECT * FROM sys.master_files WHERE [type_desc] = 'ROWS'
 
And the database [name] came back as the pre-appendage name without the "W"!
 
I've tried backup of the renamed database, tried DROP of the database, and have REATTACHED the database. While the new .mdf and .ldf from the BACKUP now have the correct name with the appended "W", the query results still gives me the old name.
 
I'm using the sys.master_files because I can't seem to find any other group method to iterate through the databases on this instance.
 
And I'd like to fix the problem not just tack a "W" onto the [name] I get using a concatenation.
 
Thanks
 
[EDIT]
 
Not only is the [name] incorrect, even after restart ...
but the [physical_name] of the master_file is reported as the new name.
 
[END EDIT]
Posted 26-Oct-12 13:32pm
RedDk10.3K
Edited 26-Oct-12 13:38pm
v2
Comments
Sergey Alexandrovich Kryukov at 26-Oct-12 19:30pm
   
Is it a question? Where?
--SA

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

The solution:
 
Concatenation of "W" to the end of the [name].
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 215
1 George Jonsson 175
2 Kornfeld Eliyahu Peter 159
3 PIEBALDconsult 110
4 Richard MacCutchan 85
0 OriginalGriff 6,080
1 DamithSL 4,648
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,624
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 29 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100