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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | dasuPosting Yak  Master
 
 
                                        104 Posts | 
                                            
                                            |  Posted - 2004-08-17 : 10:27:52 
 |  
                                            | hello, this is my querry like when ever iam trying to execute the followingactually that will display no of row sin that selected path file so i have to catch that value can u suggest me better solution for thisSET @strTempCommand = 'type '+ @strPathName + ' | Find /C /V "TEXT!NOT!IN!RECORD"'EXEC master..xp_cmdshell  @strTempComman |  |  
                                    | SeventhnightMaster Smack Fu Yak Hacker
 
 
                                    2878 Posts |  |  
                                |  |  |  |