Issue with xp_create_subdir

• Vinu verma

  Right there with Babe

  Points: 795

  More actions

  September 7, 2007 at 2:49 am

  #180945

  Hi,

  I am trying to execute the following command

  EXECUTE

  master.dbo.xp_create_subdir '\\ServerShare\SQLBackup$\Server03\UserDBs\DB1'

  GO

  There are no folders in the following location '\\ServerShare\SQLBackup$\Server03\UserDBs\

  But still I am receiving this error

  Msg 22048, Level 16, State 1, Line 0

  xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'

  Any idea why SQL Server throws such an error

  Please help

  Vinu

• Gonzalo Cuadri - Jujuy

  SSC Veteran

  Points: 207

  More actions

  September 7, 2007 at 6:58 am

  #732118

  Check the permissions for that folders .

  Sorry, my english is poor.