HOW to use the FILENAME statement

• mandycandy07

  Newbie

  Points: 7

  More actions

  April 18, 2011 at 6:02 am

  #237857

  I am creating a data base and i am using the ON statement to create the logical name and i specify the FILENAME but when i debug i have an operating system error that says i cant write the file , what must i do

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  April 18, 2011 at 6:44 am

  #1312714

  grant the sql service account access to the folder you are trying to create the database file in.

  ---------------------------------------------------------------------