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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy