SQL Server Performance

Do U know this?

Discussion in 'The Lighter Side of Being a DBA' started by Reddy, Oct 14, 2005.

  1. Reddy New Member

    Can any one know the reason why we are unable to create a folder with the name "con",try it anywhere on ur computer.

    Thanks!
    "He laughs best who laughs last"

  2. mmarovic Active Member

    Hey, that's true. I have no idea why.
  3. Reddy New Member

    Even I dont know..looks like MS is not aware of this.

    Thanks!
    "He laughs best who laughs last"

  4. Adriaan New Member

    Error message is that the file name is invalid, so 'con' must be a reserved word - perhaps a DOS command? Entering Help CON or con /? in a DOS box doesn't help, it returns ' ' is not a valid command - so we can only guess what it is.

    Please do not enter conn a DOS box until someone tells you that it is safe to do so. It's probably not at the same danger level as some of the other DOS commands, but you never know!
  5. Madhivanan Moderator

    quote:Originally posted by Reddy

    Can any one know the reason why we are unable to create a folder with the name "con",try it anywhere on ur computer.

    Thanks!
    "He laughs best who laughs last"


    Refer this
    http://www.kbalertz.com/kb_279868.aspx

    Madhivanan

    Failing to plan is Planning to fail
  6. ranjitjain New Member

    Interesting observation reddy....
    I didn't knew this
  7. ghemant Moderator

    Hi,<br />i have query it to Microsoft and the reply is as :<br /><br /> <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Thank you for contacting Microsoft Connect Customer Service.<br /><br />My name is Charmaine and the issue that you brought to our notice is that you need technical assistance to create folders with name con, aux, com1, lpt1, nul.<br />With regards to your query, we wish to inform you that the following reserved device names should not be used as the name of a file:<br /><br /><br />CON, PRN, AUX, CLOCK$, NUL, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9, LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, and LPT9. <br /><br /><br />You must avoid using these names as a file name suffix or file name body as these are the reserved words for operating system, so you have to avoid names such as aux.c, file.aux or NUL.txt.<br /> <br /><br />We do hope that we have been able to resolve your issue up to your satisfaction.<br /><br /><br />We would be happy to assist you further with any query related to Microsoft. <br /><br /><br />Warm regards<br /><br />Charmaine Sheena Singh<br />Microsoft Connect – Customer Services<br />Tel: +91-11-26292640<br />Fax: +91-11-26292649<br />Toll free: 1-600-11-1100<br />Email: connect@microsoft.com <br />Website:<a target="_blank" href=http://www.microsoft.com/india>http://www.microsoft.com/india</a> <hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"> <br /> <br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />Regards <br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  8. Chappy New Member

    There were some horrible windows exploits a few years ago which could take out a windows machine by attempting to access a device such as CON, it even worked using a hyperlink

    I think Microsoft issued a security to update to prevent this
  9. Chappy New Member

    Hm ok, it was a few more years ago than I thought <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /<a target="_blank" href=http://vil.nai.com/vil/content/v_99556.htm>http://vil.nai.com/vil/content/v_99556.htm</a>
  10. Twan New Member

    con is the console device. You can use it in the command

    copy con test.txt

    then type what you want and press [ctrl+z, enter] to save the contents to the file

    Cheers
    Twan
  11. Madhivanan Moderator

    &gt;&gt;copy con test.txt<br /><br />Very nice [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  12. Adriaan New Member

    Feels like I've fallen into the hands of a regression therapist (yach) - Twan, you really bring back some forgotten memories!
  13. Twan New Member

    sorry... been in this industry way too long <img src='/community/emoticons/emotion-5.gif' alt=';-)' />
  14. bradmcgehee New Member

    I also used to use con a lot back in the long forgotten DOS days. I can't even remember when I last used it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  15. FrankKalis Moderator

    Hey, at least do we know, that there were computers before Windows...<br />Any die-hard bash freak here? [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />

Share This Page