Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kieran5405
Yak Posting Veteran
96 Posts |
 Posted - 2008-06-20 : 10:57:59
|
| Hi,I am trying to create a stored proc to get the last modified date of a .BAK file stored on the server.I am looking at XP_CMDSHELL but can not see any syntax methods online.Any help appreciated... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-20 : 13:27:15
|
| Check out dir /? from a cmd window. xp_cmdshell just allows you to run DOS commands. So start in a cmd window with your testing.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Last mod. date of file