InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:13:18 GMT20http://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspx:) I am thankful you appreciate it. It is all about the journey and learning out realistic limitation in it! Thank you for helping me along that journey!![quote][b]Jeff Moden (5/31/2012)[/b][hr]I sure do appreciate you taking the time for the feedbback here. As a side bar, what you just said makes me real happy that I walked away from the front end world back in 2002. ;-)[/quote]Thu, 31 May 2012 20:46:22 GMTTeraByteMehttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxI sure do appreciate you taking the time for the feedbback here. As a side bar, what you just said makes me real happy that I walked away from the front end world back in 2002. ;-)Thu, 31 May 2012 20:30:38 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxThe only way we could get this to work was to add a flag to the program that bypasses the prompt. Logical because you can't tell a program to do something that it hasn't been written to do, and the only alternative to the prompt seemed to be to send a key stroke to the console once it was there. Not practical at all.Thu, 31 May 2012 20:03:49 GMTTeraByteMehttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxBe advised that some of these apps just don't work this way. They sometimes require the human element to be present at just the right time.Tue, 29 May 2012 06:16:13 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxI tried every way icould think of to get it to work with get-process but no luck. I will let you know once i confirm.[quote][b]Jeff Moden (5/27/2012)[/b][hr]Thanks for the feedback. I'd be i[font=][/font]nterested in knowing if it actually works on the one you wanted it to. Let me know, if yhou get the chance.[/quote]Mon, 28 May 2012 17:51:00 GMTTeraByteMehttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxThanks for the feedback. I'd be interested in knowing if it actually works on the one you wanted it to. Let me know, if yhou get the chance.Sun, 27 May 2012 21:11:44 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxThat trick works with the exe that I just created will see if it works with the one I actually have to run it against. Thanks![quote][b]Jeff Moden (5/26/2012)[/b][hr]It sometimes depends on the executable, but I've had good luck with this problem in the past.First, make a text file called Y.txt. It should contain 1 character. That character is "Y" without the quotes. Make sure that when you enter the character to press the [Enter] key after the "Y" in whatever editor you're creating the file in.Then, when you execute the exe, include a redirected input from the Y.txt file. From a command prompt, it would look like the following...[code="plain"]C:\DB Tools\DBCleaner\DbCleaner.exe < C:\somepath\Y.txt[/code]... where "C:\somepath\" is the actual folder that the Y.txt file lives in.I don't know if "Start-Process -filePath" will handle such redirection, though.[/quote]Sun, 27 May 2012 18:11:07 GMTTeraByteMehttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxIt sometimes depends on the executable, but I've had good luck with this problem in the past.First, make a text file called Y.txt. It should contain 1 character. That character is "Y" without the quotes. Make sure that when you enter the character to press the [Enter] key after the "Y" in whatever editor you're creating the file in.Then, when you execute the exe, include a redirected input from the Y.txt file. From a command prompt, it would look like the following...[code="plain"]C:\DB Tools\DBCleaner\DbCleaner.exe < C:\somepath\Y.txt[/code]... where "C:\somepath\" is the actual folder that the Y.txt file lives in.I don't know if "Start-Process -filePath" will handle such redirection, though.Sat, 26 May 2012 13:06:13 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxThis will execute the application but as a result it opens in a cmd window and how to make the default selection of Y (Yes) from the window? Note, the executable doesn't take parameters as input.Start-Process -filePath "C:\DB Tools\DBCleaner\DbCleaner.exe"Fri, 25 May 2012 18:16:12 GMTTeraByteMehttp://www.sqlservercentral.com/Forums/Topic1306873-1351-1.aspxI have an executable that when ran opens a cmd windows, gives some information, and then prompts for a selection at the prompt as show below:"Would you like to proceed? [Y\N]"I am trying to figure out how best to program the automation of a response of Yes via PowerShell. I have looked at Invoke-Cmd but not getting how I can use this in the way that I need things to work.Any ideas?Thanks!Fri, 25 May 2012 18:01:20 GMTTeraByteMe