Jeff Moden (10/14/2015)

Understood but why is it necessary for the user...

My first thought was that you were trying to call an external DLL. Could you verify that that there aren't external DLLs that it wants to use?

CEWII

Personally I am a big fan of using Azure BLOB store for both short and long term backups.

CEWII

Why are you even accepting the file? Notify the vendor that the file format is set and that alterations are not tolerated. Its clear, if they are adding...

Listen, I like the idea and most of the execution, I like code re-use but don't like having to deal with the GAC. I probably would have added the...

What is the difference in permissions between the SQL Server and the user running it at the command line? I'm guessing that the working directory may not allowed for...

yw

CEWII

Since an execute process task calls a command I would surmise you don't have the executable set correctly for that process.. And I would guess that the other two...

That is correct, per the link I sent.

CEWII

I didn't think you could pass an object between, virtually everything else yes.. But not an object.

CEWII

I don't think we can answer that question, but I...

I would suggest looking here for your answers: http://technet.microsoft.com/en-us/library/ff878487.aspx

CEWII

While I think what you are asking IS physically possible, the timing to achieve it is astronomically difficult. In short, I wouldn't even bother to worry about it.

I view...

Yes it is. It will run just fine. SQL 2012 doesn't require Windows Server 2012 and SQL 2008 doesn't require Windows 2008. The minimum requirement for both...

You might look at this thread: http://www.sqlservercentral.com/Forums/Topic737169-148-1.aspx#bm1420339

CEWII