SQLDenis shared with me the the -accepteula switch which is available on all the sysinternals tools. This also fixed the problem

Exec xp_cmdshell 'C:\Contig\contig.exe -v -accepteula "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBA.mdf"'

It was the user agreement coming up in the background and waiting for the Accept command.

Here is how you'll need to handle it, or how I fixed the issue anyhow.

Open...

I actually think it may be the software license agreement which would make sense from the hanging issue. I only say that because I have successfully recreated your problem....

Noticed teh -v in your call also. Try use -q to prevent anything from possible waiting forthe command to exit. This would cause the events to show as...

When you are running this from the query window, are you running it local on the server or remote from your machine? It's possible you're losing the credentials from...

This is a great article and a technique overlooked often for increasing performance.

After reading the article I had a few things that I was going to add but I read...

I don't think it should be called negative at all. Other than a poor reply on the English which should be ignored as we must understand we are not...

I think the title was misleading, "Some Cool Scripts". This is backup 101 as stated. The article wasn't bad and good for a newb but definitely draws attention...

Yes you can run an SSIS package from command line (batch or what not) just as you could use dtsrun.exe to do the same in 2K. the executable name...