fhfh (12/13/2012)
I mapped the network drive in sql sevrer box and i have ran thisEXEC xp_cmdshell 'FORFILES /p I:\ /m *.* /d -30 /c "CMD /C del /Q /F @FILE"'
ERROR: The specified directory does not exist.:w00t:
I hope you might know the risk about cmdshell. You can use the 'Net use with uname and password' to access the share.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/