Results 1 to 11 of 11

Thread: files in sql

Hybrid View

  1. #1
    Join Date
    Oct 2006
    Posts
    9

    files in sql

    If anybody knows can you please let me know how to view the files in sql server

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Files stored in sql table as image data? Need third party tools.

  3. #3
    Join Date
    Oct 2006
    Posts
    9
    can you elaborate it plz. I faced this question in an interview.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    You didn't give me details yet.

  5. #5
    Join Date
    Oct 2006
    Posts
    9
    if we want to see the files that are present in sql server how we can see the files and directories.

  6. #6
    Join Date
    Dec 2004
    Posts
    502
    I think you're looking for this:

    SELECT * FROM master..sysaltfiles

  7. #7
    Join Date
    Oct 2006
    Posts
    9
    Thanks. Is there any way to see the files and directories present in particular server.

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    Query master..sysdatabases table.

  9. #9
    Join Date
    Oct 2006
    Posts
    9
    Can you please tell me the difference between these two.
    select * from master..sysdatabases
    select * from master..sysaltfiles

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    sysdatabases gives you more db info in the instance, while sysaltfiles gives you more db files info.

  11. #11
    Join Date
    Oct 2006
    Posts
    9
    Thanks. I am looking for the file info in the database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •