xp_cmdshell ??

• • Reply

  13 years ago

  by yogeshkadvekar

  yogesh kadvekar

  , India

  Joined 14 years ago

  declare @Command varchar (500)
  
  Set @Command = 'D:\yogesh\yogesh.csv'
  EXEC master..xp_cmdshell @Command
  
  
  

  is this work in query analyser  ?

  if no then is there any other way to do this ?

  i just want to open file  using  sql query 

   

   

  Report abuse
• • Reply

  13 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 years ago

  Try building up the entire xp_cmdshell statement and executing that instead.

  declare @Command nvarchar (500)
  Set @Command = 'EXEC master..xp_cmdshell ''D:\yogesh\yogesh.csv'''
  exec sp_executesql @Command
  
  

   

   

   

  Report abuse
• • Reply

  13 years ago

  by yogeshkadvekar

  yogesh kadvekar

  , India

  Joined 14 years ago

  hi Timl,

  its not working!!

  Report abuse
• • Reply

  13 years ago

  by breakpoint

  breakpoint

  , United States

  Joined 13 years ago

  Examples...

  http://msdn2.microsoft.com/en-us/library/Aa260689(SQL.80).aspx

  Report abuse
• • Reply

  13 years ago

  by Jack V

  Jack Vamvas

  , United Kingdom

  Joined 13 years ago

  You say it's not working.What error are you getting? Is the user you're using have execute permissions for the xp_cmdshell ?

  Report abuse