If I try to add a snippet titled "prn" (without quotes), I get an error message below. However, if I change the name it works fine.

SQL Prompt cannot save this snippet to the folder:

C:\ Users\<profile>\AppData\Local\Red Gate\SQL Prompt 4\Snippets

Check that the folder is not read-only, or that it has not been deleted or renamed.
delux
0

Comments

2 comments

  • MikeyC
    PRN is a reserved file name in DOS/Windows that references your printer, so I suspect that is the problem.

    I would have though having the ".sqlpromptsnippet" extension would have prevented the problem, but I guess not.

    There are a number of other reserved names, for example COM1, LPT1, etc. that can't be used.
    MikeyC
    0
  • delux
    Wow, I guess I've just never tried to name something that. I just tried to create a file prn.txt and it did not work. Good catch!

    Thanks!
    delux
    0

Add comment

Please sign in to leave a comment.