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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 XP_CMDSHELL

Author  Topic 

Chris_Kelley
Posting Yak Master

114 Posts

Posted - 2014-10-15 : 15:52:39
c

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-15 : 16:00:35
try the /a:-d
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-10-15 : 16:01:58
try this:
EXEC XP_CMDSHELL 'dir /s /b /on /A-D "\\Adsnt4\d$\data\collection\CLAIMS ELECT FILED\*\*.*"'
Go to Top of Page

Chris_Kelley
Posting Yak Master

114 Posts

Posted - 2014-10-15 : 16:55:41
c
Go to Top of Page

Chris_Kelley
Posting Yak Master

114 Posts

Posted - 2014-10-15 : 16:59:40
c
Go to Top of Page
   

- Advertisement -