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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 what this code will do ?

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-11-30 : 00:35:17
DECLARE @cmd varchar(1000)
SET @cmd = 'ftp -i -s:E:\Earth\UK\cmds.txt mail.earthmove.com'
EXEC master..xp_cmdshell @cmd


Please help me to understand what exactly this code will do ?

Thanks,
Gangadhara MS
SQL Developer and DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-30 : 01:04:29
It's going to run a script on an ftp server. Open up the cmds.txt file to see what it's going to do.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -