Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    10

    Question Unanswered: Directory Structure not known then how to provide file path for a FILENAME param

    Hi,

    I am adding a file to a filegroup on a remote system, and i don't know the direcotry structure of that machine, how can i provide the path for FILENAME param.

    ALTER DATABASE TESTDB ADD FILE (NAME = N'TESTFILE', FILENAME = N'physicalfilepath.ndf') TO FILEGROUP TESTFILEGROUP

    Warm Regards,
    Mushq

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    not sure where the problem is. if u r creating the file, u should be placing it wherever u want. however, if u want to know the path of an existing db try this

    sp_helpdb DB_Name

Posting Permissions

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