-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: awesom_099
Message 2 in Discussion


hi rishi,
 
Tell me is your db is at ur local machine..(as ur 
using c:\ )
bcoz the .bat file has to be loaded in the machine 
where ur db lies..
else you'll getting this problem...
correct me guys if i am wrong..
 
rgds,
 
Murali
 

  ----- Original Message ----- 
  From: 
  Rishi61 
  To: BDOTNET 
  Sent: Tuesday, February 17, 2004 4:04 
  PM
  Subject: SQL Guru's : How to call a batch 
  file from Sql Stored procedures
  

  
    
      
      New Message on BDOTNET
    
      

  SQL 
    Guru's : How to call a batch file from Sql Stored 
    procedures


    
      
      
        Reply

        
          
            
            
               
              Reply to Sender   Recommend 
              Message 1 in 
                Discussion 
      
        
          
            
            
              From: Rishi61 
            
              

                Hi guys ,
                this is very urgent,by thursday I have to finish 
this.
                Can anybody know , how to call a batch file from the sql 
                stored procedures.
                I have created a batch file called "test.bat" in c:\ and 
                from query analyzer I tried the following commands
                 
                exec master..xp_cmdshell 'test'
                
                exec master..xp_cmdshell 'test.bat'
                
                exec master..xp_cmdshell 'c:\test'
                exec 
                master..xp_cmdshell 'c:\test.bat'
                the error I was getting is "not recognized as internal or 
                external command"
                 
                I am desparately waiting for the solution.
                 
                thx & regs
                Rishi
View other groups in this 
    category. 



-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to