Click here to Skip to main content
11,644,731 members (61,010 online)
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 12:32pm
RedDk11.8K
Edited 26-Oct-12 12: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 680
1 jyo.net 494
2 Sergey Alexandrovich Kryukov 454
3 Afzaal Ahmad Zeeshan 404
4 CPallini 386
0 OriginalGriff 1,020
1 Sergey Alexandrovich Kryukov 673
2 DamithSL 656
3 Afzaal Ahmad Zeeshan 652
4 CPallini 555


Advertise | Privacy | Mobile
Web04 | 2.8.150731.1 | Last Updated 29 Oct 2012
Copyright © CodeProject, 1999-2015
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