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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-30 : 08:09:03
|
| Rennie writes "Hi SQL TEAMI am currently trying to execute a batch file through xp_cmdshell and it just hangs.This batch file contains some Visual Source Safe(VSS) commands that finds the differences between 2 files, a file stored in the VSS database and a file stored in a windows directory.All the commands are self-terminating! When i run just the batch file from a windows or a command level interface, it works fine. The batch file does not wait for any user interaction. The moment i try executing it via xp_cmdshell, it just runs and runs and runs!I have in my script executed other batch files via xp_cmdshell and those work fine, so i have the necessary rights and access.I am connected to a database that i have created locally on my machine and have full rights to it!Any ideas as to why xp_cmdshell does not like VSS commands???Do i need any specific service packs or pathces??OS: WINDOWS 2000, SERVICE PACK 1VSS: Visual Studio 6SQL: 2000PLEASE HELP!Thanks in advanceRennie" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-01-30 : 11:35:32
|
| Hi,Since xp_cmdshell is running as an independent thread, make sure you're not blocking yourselfDo an sp_who2 active, check the spids, and the check sp_locks to make sure your s/p spid is not blocking the xp_cmdshell spid...happened to me the other day...had to alter how I handled my transactions within the s/p.Good LuckBrett 8-) |
 |
|
|
|
|
|
xp_cmdshell and Visual Source Safe