$$$ 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,624
    117
    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 500 Likes Award

    Sparky Zettabyte Poster Moderator

    10,718
    543
    364
    Files that are blue means they are compressed.
     
    Certifications: MSc MCSE MCSA:M MCSA:S MCITP:EA MCTS(x5) MS-900 AZ-900 Security+ Network+ A+
    WIP: Microsoft Certs
  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,624
    117
    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...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.