1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

$$$ signs in file names and files?

Discussion in 'SQL Exams' started by itdaddy, May 7, 2007.

  1. itdaddy

    itdaddy Byte Poster

    116
    0
    14
    Hey gurus

    may seems dumb but what are the $$ signs in file names
    and files for? like tempdb$er for??? and for both file names and files??

    thanks

    :eek:
     
  2. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    In most cases these files are usualy 'hidden' from normal view. The usual reason for weird characters in filenames is to improive the likelyhood that they are unique in a directory. Users tend not to use such characters.

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  3. itdaddy

    itdaddy Byte Poster

    116
    0
    14
    Hey harry

    thanks for replying; i have seen yes $$ files for
    say MS install files in blue and displayed on when unhidding these files.

    But I have also seen these files when in Microsoft SQL server directory in Program Files....not sure..why some are called this
    so for security reasons aye?

    thanks

    robert
    :eek:
     
  4. Sparky
    Highly Decorated Member Award

    Sparky Zettabyte Poster Moderator

    10,189
    296
    319
    Files that are blue means they are compressed.
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) Security+ Network+ A+
    WIP: Exchange 2007\2010
  5. Stoney

    Stoney Megabyte Poster

    731
    23
    69
    And.......

    If you type $ as the last character in the file name of a shared folder then the folder becomes hidden to users in Windows Explorer. But the folder can still be mapped. 8)
     
    Certifications: 25 + 50 metre front crawl
    WIP: MCSA - Exam 70-270
  6. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224

    I'm not very familiar with SQL Server, and don't have a copy to hand. My guess is that they are 'system' files it uses and the use of the $ character avoids filename clashes.

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  7. Crito

    Crito Banned

    505
    14
    0
    You probably installed SQL Server as a named instance, so

    C:\Program Files\Microsoft SQL Server\MSSQL$Server1
    and
    C:\Program Files\Microsoft SQL Server\MSSQL$Server2

    would be two completely different database servers.
     
    Certifications: A few
    WIP: none

Share This Page

Loading...