Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    44

    Unanswered: How to change a data file name

    Hi All,

    Is anyone can help me to change a existing data file into a new new name?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The logical name of the file, or the actual path and filename of the .NDF file?

  3. #3
    Join Date
    May 2004
    Posts
    44
    Logical name.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Alter database DB modify file (name = 'old_name_of_file', newname = 'new_name_of_file')

  5. #5
    Join Date
    May 2004
    Posts
    44

    Thanks a lot.

    It worked good.
    Thank you MCrowley, it's very helpful.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •