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 2000 Forums
 Transact-SQL (2000)
 shell

Author  Topic 

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2004-06-23 : 10:52:03
do you why when I run this sql it gives an error as invalid column name?
Thanks

declare @Filename varchar(1000)

set @Filename = "\\W-I55ZB6B7\c$\farshad\WinZip\wzunzip.exe C:\01-01-2004-pershing.zip capt.capt.asc \\W-I55ZB6B7\c$\farshad\downloads"
execute master..xp_cmdshell @Filename

raymondpeacock
Constraint Violating Yak Guru

367 Posts

Posted - 2004-06-23 : 10:59:22
Use single quotes instead of double quotes.


Raymond
Go to Top of Page
   

- Advertisement -