Post reply

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

  • April 23, 2015 at 2:02 pm

    #300107

    Using the below xp to create folder to a network share. But getting error:-

    EXECUTE master.dbo.xp_create_subdir @chkdirectory

    Msg 22048, Level 16, State 1, Line 0

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

    Is this purely a permission issue or something else? Please suggest

    Thanks.

  • April 24, 2015 at 8:16 am

    #1793280

    what is passed as the @chkdirectory parameter

  • April 24, 2015 at 8:21 am

    #1793284

    Shared path. It is properly passed as s variable, I verified.

    Thanks.

  • April 24, 2015 at 8:53 am

    #1793298

    what happens if you pass that path manually as a test? exec xp_create_subdir '..testpath..'

  • April 24, 2015 at 9:06 am

    #1793303

    Same failure.

    Thanks.

  • April 24, 2015 at 9:11 am

    #1793307

    have you tried the same thing on another server just to test? exactly how is the path written? I don't need to see dir names or drives just X:\\XXXX\XXX for example. any dots ('.') in the path?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply