How get file date with scripts

[topcatalpha]

Hi, i want to retrieve creationDate and time from a file on the server HD by using a query. anyone any idea how i can do this? thx Kurt

[Wendelius]

Hi, First thing that comes in mind is to create a small assembly using c#. Implement a method to extract file info you need and then install and register it to SQL Server. After that you can use this custom function in t-sql. Mika

[Ashfield]

Take a look at xp_cmdshell.

Bob Ashfield Consultants Ltd

[topcatalpha]

OK thx. if i can get the result of XP_CmdShell, i can manage it. greetz Kurt