If anybody knows can you please let me know how to view the files in sql server
Printable View
If anybody knows can you please let me know how to view the files in sql server
Files stored in sql table as image data? Need third party tools.
can you elaborate it plz. I faced this question in an interview.
You didn't give me details yet.
if we want to see the files that are present in sql server how we can see the files and directories.
I think you're looking for this:
SELECT * FROM master..sysaltfiles
Thanks. Is there any way to see the files and directories present in particular server.
Query master..sysdatabases table.
Can you please tell me the difference between these two.
select * from master..sysdatabases
select * from master..sysaltfiles
sysdatabases gives you more db info in the instance, while sysaltfiles gives you more db files info.
Thanks. I am looking for the file info in the database