When I use xp_cmdshell to zip files or hash files on a server in a stored procedure with a nex following T-sql statement to write a datetime into a log table, is this datetime after the zip cmd or hash cmd has finished on the server (wait for reply), or is it just after sending the cmd's to the server (fire-and-forget)?
xp_cmdshell in sql server - fire-and-forget or wait-for-reply?
1.1k Views Asked by Gideon At
1
There are 1 best solutions below
Related Questions in CMD
- Execute a command over multiple files
- R CMD recognize only some commands
- FIle download via cmd in windows using HTML
- CMD/BATCH - Had to run batch script 3 times to get full result
- Lauching program via command in php
- CMD specifying columns to save?
- Set environment in current cmd using batch script
- Running a powershell command inside cmd script and replacing string content
- Is it possible to close every application via a batch file?
- Implementing timed input in batch file. (countdown to a minute)
- How to remove "Remote desktop disconnected" window and close mstsc.exe
- Extracting specific registry key from REG QUERY based on search string
- Blank path in environment variable causing elevated command prompt to not respond
- CMD - Takeown giving "The data area passed to a system call is too small"
- Compare 2 text files and display the difference between them (PowerShell or CMD)
Related Questions in XP-CMDSHELL
- SQL Server: The type initializer for 'Oracle.DataAccess.Client.OracleParameter' threw an exception
- Using xp_cmdshell to export all tables into separate txt files
- How do I resolve this "Access is denied" error which occurs when using xp_cmdshell in Microsoft SQL?
- xp_cmdshell copy command seldom fails
- xp_cmdshell in sql server - fire-and-forget or wait-for-reply?
- SQL Server 2008 R2 to run external winform app, does not work, still showing "executing query"
- SQL Server 2000 xp_cmdshell
- SQL Server Log File
- bcp export data to txt having arabic filename
- What else I can use than xp_cmdshell
- How to export resultset of a procedure with parameters using T-SQL command in SQL Azure database
- xp_cmdshell error with remote DB connection
- Execute commands within tsql
- Get file contents via xp_cmdshell
- Write to file with xp_cmdshell in UTF-8
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
xp_cmdshellwaits for the end of the executed command.Note "xp_cmdshell operates synchronously" from the documentation.
Note that this also makes sense in other ways, since you get the result of the executed command "Any output is returned as rows of text.".