Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
How can I get file information using SQL Server?
Neil Pike
May 10, 1999
1 Min Read
A. Using the undocumented xp_getfiledetails procedure :-
create table #info (
alt_namevarchar(255) null,
size_in_bytesint null,
creation_date int null,
creation_timeint null,
last_written_dateint null,
last_written_timeint null,
last_accessed_dateint null,
last_accessed_timeint null,
attributesint null
)
insert #info exec master..xp_getfiledetails 'C:DirectoryFile.nam'
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)